SQL Data Analyst — Hard A CTE is defined WITH cte AS (SELECT …). Which statement about CTEs is true? A A CTE automatically creates an index on its result set B A CTE persists across multiple queries in the same session C A CTE is re-evaluated each time it is referenced within the same query unless materialized by the optimizer D A CTE can only be referenced once in the main query Show explanation
