Carbon Ads · 728×90
Input SQL
Formatted
SELECT
u.id,
u.name,
count(o.id) AS orders
FROM
users u
LEFT JOIN orders o ON o.user_id = u.id
WHERE
u.created_at > '2024-01-01'
AND u.active = TRUE
GROUP BY
u.id,
u.name
HAVING
count(o.id) > 2
ORDER BY
orders DESC
LIMIT
20;