SQL Murder Mystery

A crime has been committed in SQL City. Use your SQL skills to interrogate the database, find the clues, and deduce the identity of the murderer.

Type SQL queries into the terminal to investigate.

When you know who did it, type:
GUESS 'First Last'

Crime: Murder Queries: 0 Score: 10000

Connecting to SQL City PD Database... connected.

Type SQL queries below. Start your investigation by checking the `crime_scene_report` table for a murder that occurred on Jan 15, 2023 in SQL City.

SELECT

*

FROM

WHERE

LIKE

JOIN

ON

AND

=

'%'

GUESS

Case Closed

Final Score: 0