AWS Athena (Presto) - multiple WITH statements
WITH "revenue" AS (,
SELECT "cik", "accession", year, quarter.
"form type" as "form_type",
CAST("value" AS bigint) as "revenue",
CAST("value" - lag("value") over (partition by "cik") AS bigint) as "increment",
ROUND("value" / lag("value") over (partition by "cik"),2) as "ratio"
FROM "gaap"
WHERE "form type" IN ('10-K') AND
"rep" = 'revenue' AND
ORDER BY "cik", "year", "quarter", "fs" desc
),
"cik_with_continuous_growth" AS (
SELECT "cik"
FROM "revenue"
WHERE "ratio" >= 1.5 AND
"year" >= 2016
GROUP BY "cik"
HAVING COUNT("ratio") >= 3
ORDER BY "cik"
)
SELECT * FROM "cik_with_continuous_growth";
have you tried with a as ( ) , b as () select * from a,b
?