APETYPE/practice
sql·passage intermediate
sql·passage intermediateDesktop Required to Type
Desktop Recommended for Code Typing
ApeType code transcription is engineered for physical mechanical and laptop keyboards with syntax navigation. Mobile on-screen keyboards cannot provide authentic typing cadence.
You can see the leaderboard hereTop Typists
view all1/ 14
1
WITH RankedSessions AS (↵
2
SELECT↵
3
user_id,↵
4
language,↵
5
wpm,↵
6
accuracy,↵
7
DENSE_RANK() OVER (↵
8
PARTITION BY language↵
9
ORDER BY wpm DESC, accuracy DESC↵
10
) as rank↵
11
FROM session_metrics sm↵
12
JOIN practice_sessions ps ON sm.session_id = ps.id↵
13
)↵
14
SELECT * FROM RankedSessions WHERE rank <= 10;
tab+enter- restart
esc- restart