avg_numeric_opt.sql « agg_apply « suites « sql « tests « essentials « yql - ydb - Mirror of YDB github repos

about summary refs log tree commit diff stats

path: root/yql/essentials/tests/sql/suites/agg_apply/avg_numeric_opt.sql

blob: 7f1249d119a711c873d3fb385fd2d58097874a97 (plain) (blame)

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

SELECT
    avg(key)
FROM (values (1),(null),(3)) as a(key)