Case 4

At an archaeological dig in Mesopotamia, tensions run high among the team members living in close quarters. One afternoon, Louise Leidner—the beautiful and enigmatic wife of the expedition leader—is found dead in her bedroom, struck fatally on the head.

The window was barred and the only entrance was under constant watch, leaving the circumstances of her murder baffling.

Your mission: Use SQL to reconstruct the sequence of events, verify alibi details and uncover who murdered Louise Leidner at the dig site.

Let's Investigate