Legible? Absolutely. But it's important to keep in mind that CTE's are optimization fences. Optimizations like predicate pushdown are not currently available. M

Legible? Absolutely. But it's important to keep in mind that CTE's are optimization fences. Optimizations like predicate pushdown are not currently available. More complicated queries may benefit from being rewritten with subqueries.