yql/essentials/tests/sql/suites/aggregate/percentiles_grouped_expr.sql


1
2
3
4
5
6
7
8

select
  median(val + 1) as med,
  median(distinct val + 1) as distinct_med,
  percentile(val + 1, 0.8) as p80
from (
    select key, cast(value as int) as val from plato.Input
)
group by key order by med;