Développement

Formateur SQL

Formate et embellit des requêtes SQL avec indentation et mise en majuscules des mots-clés

SQL brut

SQL formaté

SELECT u.id,
 u.name,
 u.email,
 COUNT(o.id) AS order_count
FROM users u
LEFT
JOIN orders o ON u.id = o.user_id
WHERE u.active = 1
 AND u.created_at > '2024-01-01'
GROUP BY u.id,
 u.name,
 u.email
HAVING COUNT(o.id) > 0
ORDER BY order_count desc
LIMIT 50

Chargement…