Justryuz

-- https://github.com/hristo2612/SQLNoir

-- Case #001: The Vanishing Briefcase
-- Set in the gritty 1980s, a valuable briefcase has disappeared from the Blue Note Lounge.
select * from crime_scene where location = 'Blue Note Lounge'
-- id	date	type	description
-- 76	19851120	theft	A briefcase containing sensitive documents vanished. A witness reported a man in a trench coat with a scar on his left cheek fleeing the scene.
select * from suspects where attire = 'trench coat' AND scar = 'left cheek'
-- id	name
-- 3	Frankie Lombardi