Developer Academy

SQL

Drills ( ) , . =

Type it exactly as written, including indentation and line breaks. Press Enter at the end of each line.

0wpm

100% acc

0:00Time

SELECT u.id, u.email, COUNT(s.id) AS sessions, AVG(s.net_wpm) AS avg_wpm FROM users u JOIN typing_sessions s ON s.user_id = u.id WHERE s.created_at >= DATE('now', '-30 days') GROUP BY u.id, u.email HAVING COUNT(s.id) > 5 ORDER BY avg_wpm DESC LIMIT 20;

Just start typing.Tabrestarts