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