At a dinner party in London, the enigmatic Mr. Shaitana invites four detectives and four guests he privately hints have committed murder in the past they got away with. After dinner, the guests divide into two bridge tables while their host remains in the same room, watching the play. By the end of the evening, Mr. Shaitana is found stabbed to death in his chair, apparently.
With only the four bridge players in proximity, the crime hinges not on physical evidence but on psychology, card play, and carefully observed behavior. Each suspect has a past shadowed by suspicion—and one of them has killed again.
Your mission: Use SQL to analyze bridge table rotations, reconstruct the timeline of play, and determine which guest stabbed Mr. Shaitana during the game.
Let's Investigate