CTE, CTAS

CTEはCommon Table Expression。

WITH cte1 AS (
  SELECT *
  FROM table
)
SELECT *
FROM cte1
WHERE ....

CTASは

CREATE TABLE <TABLE> AS SELECT ...