• sql – Can you create nested WITH clauses for Common Table Expressions? – Stack Overflow
• Subqueries  |  BigQuery  |  Google Cloud

WITH 
  x AS 
  (
    SELECT * FROM MyTable
  ), 
  y AS 
  (
    SELECT * FROM x
  )
SELECT * FROM y