Case 18: Endless Night

Michael Rogers, a young chauffeur, dreams of building a house on Gipsy's Acre—a beautiful but cursed plot of land. He meets Ellie Guteman, a wealthy American heiress, and they marry and build their dream home there with architect Rudolf Santonix. When Ellie dies under suspicious circumstances, the official cause is shock. But the truth is darker: the narrator himself holds the key.

Your mission: Use SQL to meet the cast, trace key events at Gipsy's Acre, identify the victims, narrow by motive, and reveal who killed Ellie.

About this case

Based on Endless Night (Agatha Christie, 1967). A young chauffeur achieves his dream by marrying a wealthy heiress and building a house on a legendary cursed plot of land. But when the bride dies under mysterious circumstances, her death becomes the beginning of a dark spiral. Someone on Gipsy's Acre has murder in mind.

What you'll practise

This advanced case requires expert-level SQL mastery:

WHERE with multiple layered conditions — to track financial motives and secret relationships
ORDER BY — to build a timeline of events leading to death
Hidden motive detection — uncovering motives that are initially concealed
Narrator analysis — understanding that perspective shapes what appears to be truth

The database

You'll query the suspect_info table, tracking everyone connected to Gipsy's Acre, their financial interests in Ellie's death, and the sequence of events that leads to tragedy.

Difficulty

Advanced. One of the final cases. Requires sophisticated analysis to pierce through layers of deception and misdirection. The truth is deliberately obscured.