mobile typing isn't scored — practice only

SELECT u.id, u.name, COUNT(o.id) AS orders

SQL · general · type the snippet below to practice

wpm0

acc100%

time–

def fib(n): a, b = 0, 1 for _ in range(n): a, b = b, a + b return a

tab indent · shift+tab outdent · ctrl+⌫ delete word · esc restart ·

about this snippet

This is the topusers snippet in SQL — 7 lines of real SQL code that exercises common patterns you'll see in production. DeveloperType scores you on net WPM and accuracy and only counts runs above 95% accuracy on the leaderboard, so practice rewards precision, not speed alone.

view source (7 lines)

SELECT u.id, u.name, COUNT(o.id) AS orders
FROM users u
LEFT JOIN orders o ON o.user_id = u.id
GROUP BY u.id, u.name
ORDER BY orders DESC
LIMIT 10;

more SQL snippets:

browse all SQL snippets →