在线 SQL 格式化工具

SELECT u.id,
u.name,
count(o.id) AS order_count
FROM users u
LEFT
JOIN orders o ON o.user_id = u.id
WHERE u.status = 'active'
  AND o.created_at >= '2026-01-01'
GROUP BY u.id,
u.name
ORDER BY order_count DESC;