yql/essentials/tests/sql/suites/window/win_func_aggr_4func.sql


1
2
3
4
5
6
7
8
9

/* postgres can not */
select
  subkey,
  2 * sum(cast(key as uint32)) over w1 as dbl_sum,
  count(key) over w1 as c,
  min(key) over w1 as mink,
  max(key) over w1 as maxk
from plato.Input window w1 as (partition by subkey order by key)
order by subkey, c;