Case 9: Five Little Pigs

Sixteen years ago, renowned artist Amyas Crale was poisoned at his remote estate. His wife Caroline was convicted and died in prison, but now their daughter seeks to prove her mother's innocence.

You must reconstruct events from five conflicting accounts—each suspect tells their version of that fateful day. Affairs, artistic rivalry, family loyalty, and financial desperation all overlap in this complex web of motives.

Your mission: Use SQL to analyze multiple perspectives, cross-reference timelines, and determine what truly happened on the day Amyas Crale died.

About this case

Based on Five Little Pigs (Agatha Christie, 1942). Sixteen years after his death, artist Amyas Crale's conviction is questioned. His widow Caroline died in prison, but new evidence suggests she may have been innocent. Five people present that day each tell conflicting versions of events.

What you'll practise

This sophisticated case demands expert-level SQL analysis:

Reconciling conflicting testimony using complex WHERE conditions
Temporal analysis across multiple overlapping accounts
Pattern matching to identify consistencies and contradictions
Building a coherent timeline from five different perspectives

The database

You'll query the suspect_info table, analyzing five distinct accounts of the same events. Each person's testimony contains both facts and interpretations. Separating truth from bias is essential.

Difficulty

Advanced. One of the most analytically demanding cases. Requires sophisticated use of SQL to reconcile conflicting data and construct a coherent narrative from incomplete, biased, or contradictory information.