PrestoでWITHを複数使う こういう書き方なんだけど WITH a AS ( SELECT * FROM a ), b AS ( SELECT * FROM b ) SELECT COUNT(1) FROM a INNER JOIN b ON a.id = b.id ドキュメントに書いてあるじゃんか。コンマで区切ろう。 WITH t1 AS (SELECT a, MAX(b) AS b FROM x GROUP BY a), t2 AS (SELECT a, AVG(d) AS d FROM y G…
