distinct_columns_after_group.sql 197 B

1234
  1. /* postgres can not */
  2. select distinct avg_key, min_val from (
  3. select avg(cast(key as int)) as avg_key, min(value) as min_val from plato.Input3 group by subkey
  4. ) as x order by avg_key, min_val;