SQL Formatter

-- E-commerce monthly revenue and top customer analytics
WITH monthly_summary AS (
SELECT o.customer_id,
DATE_TRUNC('month',
o.order_date) AS order_month,
COUNT(o.id) AS total_orders,
SUM(o.total_amount) AS total_spent
FROM orders o
  INNER JOIN customers c ON c.id = o.customer_id
WHERE o.status = 'completed'
  AND o.order_date >= '2026-01-01'
GROUP BY o.customer_id,
DATE_TRUNC('month',
o.order_date)
HAVING SUM(o.total_amount) > 500)
SELECT c.id,
c.full_name,
c.email,
m.order_month,
m.total_orders,
m.total_spent
FROM monthly_summary m
  LEFT JOIN customers c ON c.id = m.customer_id
ORDER BY m.total_spent DESC,
m.order_month ASC
LIMIT 50
OFFSET 0;