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

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