Common Table Expressions (CTEs)

A CTE is a named temporary result set that exists only during query execution.

Syntax

WITH cte_name AS (
    SELECT ...
)
SELECT * FROM cte_name;

Benefits

• Readability: Name complex subqueries
• Reusability: Use the same CTE multiple times
• Organization: Break complex queries into steps

Your Task

Create a CTE called expensive_products that selects products where price > 100.

Then select the name and price from your CTE, ordered by price descending.