Common Table Expressions (CTEs)

Subqueries work, but they nest. One level deep is fine. Two levels deep is tolerable. Three levels deep and you're reading the query inside-out, losing track of what each layer does.

Common Table Expressions (CTEs) solve this by letting you name intermediate steps and write them top-to-bottom, in the order you think about the problem.