mobile typing isn't scored — practice only

UPDATE 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 update snippet in SQL — 8 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 (8 lines)

UPDATE orders
SET status = 'shipped',
    shipped_at = NOW()
WHERE id IN (
    SELECT id FROM orders
    WHERE status = 'paid' AND paid_at < NOW() - INTERVAL '1 day'
);

more SQL snippets:

browse all SQL snippets →