yql/essentials/tests/sql/suites/aggregate/avg_and_sum_float.sql


1
2
3
4
5
6
7
8

/* syntax version 1 */
select
    key,
    avg(cast(subkey as Float)) as avg,
    sum(cast(subkey as Float)) as sum,
from plato.Input
group by key
order by key;