yql/essentials/tests/sql/suites/subselect/order_by_source.sqlx


1
2
3
4
5
6
7
8
9

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

SELECT * FROM $input ORDER BY (SELECT Avg(v) FROM $input), k, v;