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

select count(distinct key) as count, avg(numKey) as avg from (select key, cast(key as int) as numKey, value from plato.Input2) as x group by value order by count;