The Riverside Case

River City · January 3, 2024

0 XP

❝

Case Brief

A murder was committed on January 3, 2024 in River City. Start by querying the crime_scene_report table to find details about the case.

Your objective

Find the killer

Field Notes

Database Schema3 tables · click a table to query it

pkfk

date

type

description

city

⬥id

name

address_number

address_street_name

↗ssn

↗person_id

transcript

query.sql

⌘↵ to run

⚖

Found the killer? Name the murderer to close the case.