Basic CTEs

What is a CTE?

A Common Table Expression (CTE) is a named temporary result set defined with WITH. It makes complex queries readable.

WITH active_users AS (
  SELECT * FROM users WHERE last_login > NOW() - INTERVAL '30 days'
)
SELECT COUNT(*) FROM active_users;