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

select COUNT(DISTINCT d9) from alltypes;