Case 2

In the quiet village of King’s Abbot, the wealthy widower Roger Ackroyd was found dead in his study late last night. He had received a mysterious phone call just before bedtime and when his niece discovered him, he lay slumped over his desk—bludgeoned from behind.

A shattered telephone receiver lay on the floor. The study’s door and windows were locked from the inside and no footprints could be traced in the gardens outside.

Your mission: Use SQL to cross-check alibis, analyze the timeline of events and uncover the truth behind Roger Ackroyd’s murder.

Let's Investigate