Disponible
Sin registro

Formateador SQL

Postgres, MySQL, SQLite — bonito.

SQL crudo

Formateado

SELECT u.id,
  u.name,
  count(o.id) AS orders,
  sum(o.total) AS revenue
FROM users u
  LEFT JOIN orders o ON o.user_id = u.id
WHERE u.active = true and o.created_at > '2026-01-01'
GROUP BY u.id,
  u.name
HAVING count(o.id) > 5
ORDER BY revenue desc
LIMIT 100