What does WITH actually filter?

Question

Accepted Answer

The CTE 'totals' computes the sum per customer: Alice=400, Bob=200. The outer query then filters to totals > 200 - only Alice (400) qualifies. CTEs (Common Table Expressions) are defined with WITH and can be referenced like a table in the subsequent query. They improve readability by breaking complex logic into named steps.