The Harbor Job

Harbor Town · February 15, 2024

0 XP

❝

Case Brief

A dock worker was found dead in Harbor Town on February 15, 2024. Two witnesses came forward. Start by checking the crime_scene_report to find out who they are.

Your objective

Find the killer

Field Notes

Database Schema4 tables · click a table to query it

pkfk

date

type

description

city

⬥id

name

address_number

address_street_name

↗ssn

⬥id

↗person_id

plate_number

car_make

car_model

↗person_id

transcript

query.sql

⌘↵ to run

⚖

Submit your verdict

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