aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/count/count.sql
blob: 9c01b874390c75ee111e5438d05ecfe3086ac42e (plain) (blame)
1
2
3
4
5
6
/* syntax version 1 */
select a, aggregate_list(b), count(*) from plato.Input group by a order by a;
select b, aggregate_list(a), count(*) from plato.Input group by b order by b;
select c, aggregate_list(a), count(*) from plato.Input group by c order by c;
select d, aggregate_list(a), count(*) from plato.Input group by d order by d;
select e, aggregate_list(a), count(*) from plato.Input group by e order by e;