yql/essentials/tests/sql/suites/agg_apply/avg_decimal.sql


1
2
3
4
5
6
7

/* syntax version 1 */
/* postgres can not */
pragma EmitAggApply;

SELECT
    avg(key)
FROM (values (Decimal("0.1",10,1)),(Decimal("0.2",10,1)),(Decimal("0.3",10,1))) as a(key)