OK, a clarification. My first attempt at a query is readable but performance is terrible. I fix the performance problem, but the query is now much less readabl

OK, a clarification. My first attempt at a query is readable but performance is terrible. I fix the performance problem, but the query is now much less readable. I use a CTE as a compromise between performance and readability.