yql/essentials/tests/sql/suites/subselect/aggregate_over.yql


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

$input = SELECT * FROM AS_TABLE([
    <|k: 1, v: 1|>,
    <|k: 2, v: 2|>,
    <|k: 3, v: 3|>,
    <|k: 4, v: 4|>,
    <|k: 5, v: 5|>,
]);

SELECT Sum(3) OVER w AS x FROM $input
WINDOW w AS (PARTITION BY 3 ORDER BY k);

SELECT Sum((SELECT 3)) OVER w AS x FROM $input
WINDOW w AS (PARTITION BY 3 ORDER BY k);

SELECT Sum((SELECT Avg(v) FROM $input)) OVER w AS x FROM $input
WINDOW w AS (PARTITION BY 3 ORDER BY k);

SELECT Sum((SELECT Avg(v) FROM $input WHERE v == 3)) OVER w AS x FROM $input
WINDOW w AS (PARTITION BY 3 ORDER BY k);