Using a CTE offers the advantages of improved readability and ease in maintenance of complex queries.

• 使用CTE可以获得提高可读性和轻松维护复杂查询的优点。