I thought T-SQL for five years and sometimes used CTEs as a way to introduce the concept of derived table subqueries to people who hadn't been exposed to them.

I have seen some horrendous queries with horrendous subqueries that would have benefitted from the readability provided by using CTEs <s>