sql-tests.testcases.distinct.withGroupBy.sql Maven / Gradle / Ivy
-- database: presto; groups: distinct; tables: nation
SELECT DISTINCT n_regionkey, COUNT(*) FROM nation
WHERE n_nationkey > 0
GROUP BY n_regionkey
-- database: presto; groups: distinct; tables: nation
SELECT DISTINCT n_regionkey, COUNT(*) FROM nation
WHERE n_nationkey > 0
GROUP BY n_regionkey