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


1
2
3
4
5
6

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

$a = select CurrentUtcDate() as _date, Just(Interval("P1W")) as parsed_lag from plato.Input;
SELECT AVG(parsed_lag) FROM  $a;