select_agg_group.sql 104 B

12345
  1. --!syntax_pg
  2. select x,count(y),min(y),max(y),sum(y)
  3. from (values (1,2),(3,4),(3,5)) u(x,y)
  4. group by x