CTEs vs Subqueries

A Common Table Expression (CTE) is similar to a subquery but is often preferable because:

1. It names the subquery upfront which can make the code easier to understand.
2. You can reference the CTE multiple times.