mobile typing isn't scored — practice only
SELECT e.name AS employee, m.name AS manager
SQL · general · type the snippet below to practice
def fib(n):
a, b = 0, 1
for _ in range(n):
a, b = b, a + b
return a
about this snippet
This is the selfjoin snippet in SQL — 5 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 (5 lines)
SELECT e.name AS employee, m.name AS manager
FROM employees e
LEFT JOIN employees m ON m.id = e.manager_id
ORDER BY manager NULLS LAST, employee;
more SQL snippets:
browse all SQL snippets →