Learn SQL by solving problems
Skip yet another video course — write SQL against real tables and get it checked instantly. The trainer includes interview questions from Yandex, Ozon, T-Bank and other companies.
- PGPostgreSQL
- MyMySQL
- ClickHouse
- BigQuery
TasksPrevNextRandomMock Interview
TaskSubmissionsAI Mentor
Five Drivers with Most Trips
The ride-hailing service is building a ranking of its busiest drivers. For every driver count the total number of their rides in the service history — regardless of ride status, cancelled ones count too. Find the top 5. Output name and ride_count. Sort by the ride count, descending.
Expected output sample
Row order matters
Topic cheatsheet 13 items
Yandex
Query 1PostgreSQLv16
SELECT d.name, COUNT(r.id) AS ride_count FROM drivers d JOIN rides r ON r.driver_id = d.id GROUP BY d.name ORDER BY ride_count DESC LIMIT 5;
Submit
Resultdriversrides
Answer accepted
| # | name | ride_count |
|---|---|---|
| 1 | Sergey | 3 |
| 2 | Maria | 2 |
| 3 | Andrew | 2 |
| 4 | Olga | 1 |
5 rows · 18ms
DB Schema
drivers
idSERIAL
nameVARCHAR(100)
cityVARCHAR(100)
ratingDECIMAL(2,1)
rides
idSERIAL
driver_idINT
priceDECIMAL(8,2)
started_atTIMESTAMP
Focus radio
Paused · SomaFM · Fluid
Lo-fiCodeAmbientSynthwave
TasksPrevNextRandomMock Interview
TaskSubmissionsAI Mentor
Five Drivers with Most Trips
The ride-hailing service is building a ranking of its busiest drivers. For every driver count the total number of their rides in the service history — regardless of ride status, cancelled ones count too. Find the top 5. Output name and ride_count. Sort by the ride count, descending.
Query 1PostgreSQLv16
SELECT d.name, COUNT(r.id) AS ride_count FROM drivers d JOIN rides r ON r.driver_id = d.id GROUP BY d.name ORDER BY ride_count DESC LIMIT 5;
Submit
Resultdriversrides
Answer accepted
- auto-graded tasks
- 1 192
- datasets
- 926
- SQL dialects
- 4
Tasks that have come up in interviews
- Meta
- Amazon
- Microsoft
- Tesla
- Spotify
- Uber
Tasks on real tables. From warm-up to interview.
Write queries against real tables: every task has its own dataset.
- 4 dialectsPostgreSQL, MySQL, ClickHouse and BigQuery — separate sandboxes.
- AI hintA new task on the topic where you make the most mistakes.
- Interview modeA server-side timer, no hints, a report after the session.
- Hidden-data checkYour answer is checked against the reference on other data, not a template.
Pick why you need SQL
A track is a set of tasks for a profession. A course is a curriculum with theory and a task in every lesson; the first chapters are free.
Pick a direction
All 12 tracksThen start with the right course
All 10 courses2 courses · 25 chapters · 160 lessons
6 courses · 47 chapters · 194 lessons
2 courses · 20 chapters · 117 lessons
Solve. Grow. Prove your level.
Practice doesn't end with a course: solve new tasks, raise your rank and prove the skill in the exam.
01 · Progress
Solve tasks — your rank grows
Every correct solution earns power. Power moves you up the weekly leaderboard and unlocks new ranks — and with each rank your hero changes.
Junior → Middle → Senior → … → Primordial · 14 ranks
1v1 duelshared clock
You
solved
01:38
VS
artem_sql
solving…
01:38
Start a duelA subscription is required to take a seat in a match.
02 · Skill check
Test yourself in the exam
The certificate is not a signup gift but the result of a passed exam: it carries a QR check and a public page.
- tasks
- 14
- minutes
- 25
- levels
- 3
- authenticity check
- QR
- No hints, and tab switches are tracked
- The certificate is publicly verifiable by QR code
SQL Arena
Certificate
Issued to
Ragnar Lothbrok
Practitioner
Skills verified
SubqueriesCTEWindow functionsHAVINGCASEDMLMulti-table JOIN
Date
6/1/2026
Verification code
B2D6118AF7C9
Score
100%
Scan to verify
sql.coderang.dev
Start free. More practice with Premium, the full path with Pro.
Every plan is a one-time payment for a period, with no auto-renewal.
Premium
If you want to practise
from $7.2/mo
- All Medium, Hard and Expert tasks
- Unlimited AI mentor
- Interview mode, exams and certificates
- +50% Power for every solve — permanently
The short version
Did not find an answer? Write to us on Telegram.
Is it free?
Yes. Every Easy-level task — including easy questions from real interviews — plus ranks, your rank hero, the sandbox and the leaderboard: free forever, no card. Premium unlocks the harder tiers (Medium, Hard, Expert), unlimited AI and Interview mode.
Which SQL dialects are supported?
PostgreSQL, MySQL and ClickHouse — we're the only trainer with ClickHouse problems. Your solution runs on a real database and is graded instantly.
Is it good for interview preparation?
Yes. There's an Interview mode with a timer and focus tracking — like a real tech screen — plus problems from Google, Meta, Microsoft, Tesla and other companies' interviews.
Do I need a card? Is there auto-renewal?
Free needs no card at all. Premium is a one-time payment per period (from $7.2/mo) — no auto-renewal, nothing charged behind your back.
SQL starts making sense the moment you write it
Open your first task — it is free and needs no card.
Solve your first taskBack to training