← My dashboard
PUZZLE 008
The library patron
Module 1 · GROUP BY+125 XP
Professor Owl
Whoever plans, studies.
Preparing an experiment like this takes a lot of studying. The library records every book that is checked out. Find out who has been reading more than usual.
Goal
Show each student and how many books they checked out (column total), sorted from highest to lowest.
Key facts
- Checkouts are in the checkouts table
- Count how many books each student checked out
⏳ Preparing data…
What the database returns
Run your query and the rows will appear here.
🎯 You solve it when your query returns exactly what the goal asks for.