aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/blocks/combine_hashed_avg.sql
blob: 8954e98fee18fec07a8b821a0a28b6ba0c9ad8b5 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
USE plato;

SELECT
    key,
    avg(1u/(4u-subkey)),
    avg(subkey),
    avg(1u),
    avg(1u/0u)
FROM Input
GROUP by key
ORDER by key