Case 3

How to solve it

1. Read the brief, then explore the tables of suspects and evidence
2. Answer 5 questions in order. Each one narrows down the suspects
3. Stuck on a question? Use Reveal Answer and keep going
4. The last question names the killer and closes the case

About this case

Based on The Mysterious Affair at Styles (Agatha Christie, 1920). A wealthy widow is poisoned in her locked bedroom at a country manor. Her much younger husband becomes the prime suspect—but is he really the killer?

What you'll practise

This intermediate case deepens your SQL skills:

• SELECT + multiple WHERE conditions — to isolate suspects with both motive and access
• ORDER BY — to build detailed timelines of movements
• BETWEEN — to check alibis against narrow time windows
• Complex AND logic — combining multiple filters to eliminate suspects

The database

You'll query the suspect_info table, tracking each person's relationship to the victim, their stated alibi, and suspicious details about their movements. The tables and their columns are shown next to every question, so you never need to memorise them.

Difficulty

Intermediate. Requires comfort with multiple AND conditions and filtering by time. More data to sift through than Case 2, with trickier alibis to verify.