Formatted SQL
sqlSELECT users.id,
users.email,
count(orders.id) as order_count
FROM users
LEFT
JOIN orders
ON orders.user_id = users.id
WHERE users.created_at >= now() - interval '30 days'
GROUP BY users.id,
users.email
ORDER BY order_count desc
LIMIT 20;