aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/aggregate/avg_with_having.sql
blob: f48f0dcfc1da37b2351b11f6f12c7261143d53ff (plain) (blame)
1
2
/* syntax version 1 */
select value, avg(cast(key as int)) + 0.3 as key from plato.Input group by value having value > "foo" order by key;