mobile typing isn't scored — practice only

SELECT

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 window snippet in SQL — 10 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 (10 lines)

SELECT
    user_id,
    created_at,
    amount,
    SUM(amount) OVER (
        PARTITION BY user_id
        ORDER BY created_at
    ) AS running_total
FROM orders;

more SQL snippets:

browse all SQL snippets →