CTEs are great for breaking down a large query into discrete steps. They're basically SQL's equivalent of a pipe function.