CTE — WITH clause-এ নামকरण query

WITH user_spend AS (
  SELECT u.id, u.name, SUM(o.total) AS total_spent
  FROM users u
  LEFT JOIN orders o ON o.user_id = u.id
  GROUP BY u.id, u.name
)
SELECT name, COALESCE(total_spent, 0) AS spent
FROM user_spend
ORDER BY spent DESC
LIMIT 5;

WITH stats AS (
  SELECT product_id, SUM(qty) AS sold
  FROM order_items
  GROUP BY product_id
),
top AS (
  SELECT product_id FROM stats ORDER BY sold DESC LIMIT 3
)
SELECT p.name FROM products p
JOIN top t ON t.product_id = p.id;