1
2
3
4
5
6
7
8
9
10
11
|
/* custom error: Unable to GROUP BY constant expression */
$input = SELECT * FROM AS_TABLE([
<|k: 1, v: 1|>, <|k: 2, v: 1|>,
<|k: 1, v: 2|>, <|k: 2, v: 2|>,
<|k: 1, v: 3|>, <|k: 2, v: 3|>,
<|k: 1, v: 4|>, <|k: 2, v: 4|>,
<|k: 1, v: 5|>, <|k: 2, v: 5|>,
]);
SELECT k, Avg(v) FROM $input GROUP BY (SELECT Avg(v) FROM $input) AS k;
|
