practice mode on phones
tap the code to type with your on-screen keyboard. phone runs are practice only — they aren't scored or added to the leaderboard.
SELECT
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 rank 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
department,
name,
salary,
RANK() OVER (PARTITION BY department ORDER BY salary DESC) AS rank
FROM employees;
more SQL snippets:
browse all SQL snippets →