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


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16

USE plato;

$src =
SELECT
    if (key != '075', AsTuple(Just(Just(key)), 123)) as k,
    subkey,
    value
FROM Input;

SELECT
    k,
    min(subkey) as min,
    max(value)  as max,
FROM $src
GROUP by k
ORDER by k