framework/resources/Functional/aggregates/aggregation/sanity/q14.sql

-- count distinct on a non grouping column
-- sum in coalesce function
select 
	count(distinct c1), 
	coalesce(sum(a1)+100, sum(a1+1)) 
from 
	t1 
group by 
	b1 
order by 
	b1;