CASE FILE · No. 007 · 1892
The Rhyme at Alderwick Hall
ALDERWICK HALL, KENSINGTON · DIFFICULTY: MISDEMEANOR
THE BRIEFING
Sir Rowan Alderwick collapsed in his locked study during a private dinner at Alderwick Hall. The window was open, someone had gone through the desk, and one page was torn from his private ledger. No guest said they had gone into the study. On the desk, next to a knocked-over ink bottle, police found a folded sheet of paper. It had no signature. Each line of the poem points to something in the records. Follow them.
POEM FOUND ON THE DESK
By the eastern stair, seen twice at night, With violet mark and cedar light. No soldier's steel, no tailor's thread, But legal ink and debt instead. A fair hand praised the pale moon low, Where private ledgers quietly show. Count each step, then weigh what's owed, One quiet name will end the road.
/ THE EVIDENCE
Database Schema
These are the tables you can query. The lines are the keys that join them. Hover a table to see what it connects to.
- suspect_idINT
- nameVARCHAR(100)
- occupationVARCHAR(100)
- relationship_to_victimVARCHAR(200)
- movement_idINT
- suspect_idINT→ suspects.suspect_id
- room_nameVARCHAR(100)
- movement_timeTIMESTAMP
- observed_byVARCHAR(100)
- notesVARCHAR(300)
- effect_idINT
- suspect_idINT→ suspects.suspect_id
- item_descriptionVARCHAR(300)
- color_noteVARCHAR(100)
- scent_noteVARCHAR(100)
- debt_idINT
- suspect_idINT→ suspects.suspect_id
- debt_typeVARCHAR(150)
- amountDECIMAL(10,2)
- statusVARCHAR(100)
- ledger_noteVARCHAR(400)
- sample_idINT
- suspect_idINT→ suspects.suspect_id
- sample_sourceVARCHAR(150)
- sample_textVARCHAR(500)
- handwriting_noteVARCHAR(840)
/ THE QUERY TERMINAL
Run your queries
Use SQL to explore the data. Each table holds part of the answer.
/ NOTES
Your notepad
Write down anything useful as you go.
Your notes and your last query are kept in this browser.
/ THE ACCUSATION
Name your suspect
Type the suspect's full name and submit.
NEXT CASE
Please Don't Check Me Out →"He checked out at ten past six. At half past six he telephoned the front desk from inside the hotel, and the line went dead."