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

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