Loading SQL...
ACUBENS Learn SQL
Welcome to Acubens

Master the Art of
SQL Databases

A comprehensive journey from basic queries to advanced database management. Learn SELECT, JOIN, subqueries, transactions, indexing, and more.

10 Chapters
20+ Programs
Self-paced
query.sql
1
2
3
4
5
6
7
8
9
10
11
SELECT
    u.name,
    COUNT(o.id) AS orders,
    SUM(o.total) AS revenue
FROM users u
LEFT JOIN orders o
    ON u.id = o.user_id
WHERE u.active = 1
GROUP BY u.id
ORDER BY revenue DESC
LIMIT 10;
Explore Topics View full course β†’