Skip to content

Instantly share code, notes, and snippets.

View roshancharlie's full-sized avatar

Roshan Kumar Sinha roshancharlie

View GitHub Profile
@roshancharlie
roshancharlie / SQL-Murder-Mystery-Solution.md
Last active February 6, 2023 13:21
The SQL Murder Mystery Walk Through

Start

Key to The SQL Murder Mystery

See the Clue As Given in Question

The crime was a murder that occurred sometime on Jan.15, 2018 and that it took place in SQL City

select * from crime_scene_report
where date=20180115 and type = 'murder' and city = 'SQL City';

Output

>Description-