• I find that derived tables make the queries more difficult to read and understand. Using CTEs allows you to move the derived table to an easy to understand construct just before the query and use it CTE name just like a table in the query simplifying the query.