SQL Formatter & Beautifier

SELECT
  u.id AS user_id,
  u.name,
  count(o.id) AS total_orders,
  sum(o.amount) AS total_spent,
  coalesce(avg(r.rating), 0) AS avg_rating
FROM
  users u
  LEFT JOIN orders o ON u.id = o.user_id
  AND o.status = 'completed'
  LEFT JOIN reviews r ON u.id = r.user_id
WHERE
  u.is_active = TRUE
  AND u.created_at >= '2025-01-01'
GROUP BY
  u.id,
  u.name
HAVING
  count(o.id) > 5
ORDER BY
  total_spent DESC
LIMIT
  50;