sql-tests.testcases.union.unionMoreThanTwoTables.sql Maven / Gradle / Ivy
-- database: presto; tables: nation; groups: union;
SELECT count(*)
FROM nation
UNION ALL
SELECT sum(n_nationkey)
FROM nation
GROUP BY n_regionkey
UNION ALL
SELECT n_regionkey
FROM nation