mobile typing isn't scored — practice only

SELECT id, title, created_at

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 recent snippet in SQL — 6 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 (6 lines)

SELECT id, title, created_at
FROM posts
WHERE created_at > NOW() - INTERVAL '7 days'
  AND published = true
ORDER BY created_at DESC;

more SQL snippets:

browse all SQL snippets →