What is the key scoping difference between a CTE defined with WITH and a derived table (subquery in FROM)?WITH c AS (SELECT 1 AS x) SELECT * FROM c, c AS c2;
