path: root/yql/essentials/tests/sql/suites/distinct/distinct_one_count.sql

select value, count(distinct key) as count from plato.Input2 group by value order by value;