count.sql 413 B

123456
  1. /* syntax version 1 */
  2. select a, aggregate_list(b), count(*) from plato.Input group by a order by a;
  3. select b, aggregate_list(a), count(*) from plato.Input group by b order by b;
  4. select c, aggregate_list(a), count(*) from plato.Input group by c order by c;
  5. select d, aggregate_list(a), count(*) from plato.Input group by d order by d;
  6. select e, aggregate_list(a), count(*) from plato.Input group by e order by e;