group_by.slt

statement ok
create table t1 (a int, b int)

statement ok
insert into t1 values (1, 2), (1, 3), (5, 4)

query IR rowsort
select a, count(b) from t1 group by a
----
1 2
5 1

statement error
select b, count(b) from t1 group by a