What is the purpose of Common Table Expressions (CTEs) in SQL?

What is the purpose of Common Table Expressions (CTEs) in SQL?

 

• To perform aggregate calculations on grouped records
• To define and store a temporary result set for the duration of a query
• To encapsulate complex queries and improve query readability and maintainability