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

-- with sum
select a1, count(distinct a1), sum(a1) from t1 group by a1;