At a luxurious seaside resort on Smugglers’ Island, the sun-soaked holiday is shattered when Arlena Marshall—a glamorous and flirtatious former actress—is found dead around noon in a secluded cove. She is discovered around 11:45 a.m. by fellow guests Patrick and Emily, lying lifeless in a cove where she had gone alone earlier that morning.
Her presence had stirred tension among the other guests, many of whom had motive to wish her harm.
Your mission: Use SQL to reconstruct the sequence of events, verify alibi details and uncover who murdered Arlena Marshall at the resort.
Let's Investigate