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

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