SQL Formatter

SELECT
  u.id,
  u.nombre,
  u.email,
  p.nombre as plan,
  COUNT(t.id) as total_transacciones
FROM
  usuarios u
  LEFT JOIN planes p ON u.plan_id = p.id
  LEFT JOIN transacciones t ON t.usuario_id = u.id
WHERE
  u.activo = 1
  AND u.created_at >= '2024-01-01'
GROUP BY
  u.id,
  u.nombre,
  u.email,
  p.nombre
HAVING
  COUNT(t.id) > 5
ORDER BY
  total_transacciones DESC
LIMIT
  50