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

select c_date, COUNT(DISTINCT c_integer) from alltypes_with_nulls group by c_date order by c_date;