-- trap: percentile_disc over a numeric column: the final function picks from the sorted values (generic ordered-set aggregate)
-- shape: trap
-- expect: agg
-- key: -
SELECT grp, percentile_disc(0.5) WITHIN GROUP (ORDER BY n2) AS med FROM t_num GROUP BY grp ORDER BY grp