The Case of the Vanishing Heiress

Background

In the quiet town of Elderwood, the grand estate of the wealthy Hawthorne family is the center of both admiration and intrigue. Recently, the family’s only heiress, Isabella Hawthorne, has gone missing under mysterious circumstances. The police are stumped, and the town is abuzz with rumors. It’s up to a skilled investigator to solve the case and uncover the truth.

Storyline

Isabella Hawthorne, a beloved figure in Elderwood, was set to inherit her family’s vast fortune and estate. But on the night of her 21th birthday party, she disappeared without a trace. The guests at the party included close family members, friends, and even a few business associates. Each of them had a motive, but the clues are as elusive as Isabella herself. Your task as the investigator is to use your SQL skills to sift through various pieces of evidence and uncover the truth. You’ll need to query the database of the Hawthorne estate’s records, interviews, and financial transactions to piece together what happened on that fateful night.


Query Results

Check If Your Guess Is Correct


Query Results