← My dashboard
PUZZLE 002
The missing microscope
Module 1 · WHERE+50 XP
Professor Owl
The most expensive microscope has vanished.
The Microscope X200 from the laboratory has disappeared. Every equipment loan is recorded, along with whether the item was returned or not.
Goal
Show student, loan_date and returned for all loans of the 'Microscope X200'.
Key facts
- The item is called 'Microscope X200'
- Loans are in the loans table
⏳ 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.