Gym - PostgreSQL

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

Output

status message rows

ready Connected to PostgreSQL Demo Database 0