Case 10: Lord Edgware Dies

Lord Edgware was found dead in his library at Regent Gate—stabbed through the neck. His estranged wife, the actress Jane Wilkinson, had been demanding a divorce, and several people had heard her say she wanted him dead. Several people did not like him, including his own family.

Your mission: Use SQL to cross-check alibis, analyze events, and uncover the killer.

About this case

Based on Lord Edgware Dies (Agatha Christie, 1933). A prominent nobleman is found stabbed in his London townhouse. His estranged wife, an actress, has publicly stated she wants him dead—but is she truly guilty, or is this a clever frame?

What you'll practise

This intermediate case demands careful SQL analysis:

WHERE with multiple conditions — to filter suspects by motive and access
ORDER BY — to reconstruct the timing of events
Complex AND logic — to eliminate suspects based on alibis
Cross-referencing testimony — identifying contradictions in statements

The database

You'll query the suspect_info table, tracking each suspect's relationship to the victim, their stated whereabouts at the time of death, and suspicious details about their movements.

Difficulty

Intermediate. Requires careful attention to multiple conflicting testimonies and the ability to identify inconsistencies in alibis.