DataLemur: Cities With Completed Trades

1
2
3
4
5
6

SELECT city, COUNT(*) AS total_orders
FROM trades JOIN users ON trades.user_id = users.user_id
WHERE status = 'Completed'
GROUP BY city
ORDER BY total_orders DESC
LIMIT 3