yql/essentials/tests/sql/suites/blocks/combine_hashed_count.sql


1
2
3
4
5
6
7
8
9
10
11
12

USE plato;

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