percentile_and_avg_grouped.sql 159 B

12
  1. /* postgres can not */
  2. select key, median(val) as med, avg(val) as avg from (select key, cast(value as int) as val from plato.Input) group by key order by key;