SQL Detective: The Database Mystery
Case Dossier #2026-05-27
Initial Crime Report
On the evening of May 27, 2026, at 22:30, the encryption key of eLearner.app was stolen from the main server in Milan. The police entered initial details in a table called `crime_scene_report`. Use the SQL console below to investigate!
Suggested First Steps:
1. Write a query to read the initial report: `SELECT * FROM crime_scene_report;` and run it. 2. Find the witnesses mentioned in the report and query the `interview` table using their identifiers (`person_id`). 3. Cross-reference the clues with the `drivers_license` and `fitcoder_member` tables to catch the thief!
Police Database Schema
crime_scene_report
date, type, description, city
person
id, name, license_plate, address_number, address_street_name, ssn
interview
person_id, transcript
drivers_license
id, age, height, eye_color, hair_color, gender, plate_number, car_make, car_model
fitcoder_member
id, person_id, name, membership_start_date, membership_status
fitcoder_check_in
membership_id, check_in_date, check_in_time, check_out_time
SQL Investigation Console
Run SQL commands to filter, join, and search through police records.
Identify the Culprit
Who is the culprit of the theft? Enter their full name to close the case.