Skip to content

Instantly share code, notes, and snippets.

@rafaelalvessa
rafaelalvessa / the_sql_murder_mystery.sql
Created December 28, 2019 16:10
Solution to The SQL Murder Mystery (https://mystery.knightlab.com)
-- Crime scene report
SELECT description
FROM crime_scene_report
WHERE type = 'murder'
AND city = 'SQL City'
AND date = '20180115';
-- Interview with first witness
SELECT transcript
FROM interview i