Summary - CTE

Write a multi-step report with multiple CTEs.

A CTE is a temporary result defined with WITH. It improves readability and allows multiple and chained use.

WITH active AS (
  SELECT * FROM customers WHERE status = 'active'
)
SELECT * FROM active;

Summary CTE query.

WITH defines a temporary result set (CTE) named active; the query after it uses it like a table. All columns are selected from active.

Exercise Summary - CTE

Summary: define and use the active CTE.

Show example solution

WITH active AS (
  SELECT * FROM customers WHERE status = 'active'
)
SELECT * FROM active;