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

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