Gym - MySQL

-- MySQL Demo Query
-- Tables: users, customers, orders
SELECT u.name, u.email, COUNT(o.id) as order_count
FROM users u
LEFT JOIN customers c ON u.id = c.user_id
LEFT JOIN orders o ON c.id = o.customer_id
GROUP BY u.id, u.name, u.email
ORDER BY order_count DESC;

Output

ready Click RUN to execute 0