framework/resources/Functional/aggregates/aggregation/count_distinct/with_group_by_c_bigint.sql

select c_bigint, COUNT(DISTINCT c_integer) from alltypes group by c_bigint order by c_bigint;