blob: 6839f96f4f5cd8602daa0b430e176d79e93ee6fc (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
-- Keep a log of any SQL queries you execute as you solve the mystery.
-- Find out what tables I can use to find information
.tables
-- What can I find in the crime_scene_reports table?
.schema crime_scene_reports
-- Find the report from July 28, 2023 and on Humphrey Street
SELECT description
FROM crime_scene_reports
WHERE year = 2023
AND month = 7
AND day = 28
AND street = "Humphrey Street";
-- crime at 10:15; Check Interviews with three people present, all mention the bakery;
|
