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.
Let's Investigate