sql-tests.testcases.with_clause.withSimpleExprInNestedFromClause.sql Maven / Gradle / Ivy
-- database: presto; groups: with_clause; tables: nation; queryType: SELECT
WITH nested AS (SELECT * FROM nation) SELECT count(*) FROM (select * FROM nested) as a