SQL Murder Mystery

SQL Detective: Learn SQL Queries by Solving Crimes | iTechVista
Case File #8921 ACTIVE
A murder occurred on Jan 15, 2024, in SQL City. Use SQL queries to investigate the crime scene reports, suspects, and evidence to solve the case.
Case Progress
Light Mode

Database Schema

crime_scene_reports
  • date (TEXT)
  • type (TEXT)
  • description (TEXT)
  • city (TEXT)
suspects
  • id (INTEGER)
  • name (TEXT)
  • license_plate (TEXT)
  • gym_membership_id (INTEGER)
gym_checkins
  • membership_id (INTEGER)
  • check_in_date (TEXT)
drivers_license
  • id (INTEGER)
  • age (INTEGER)
  • height (INTEGER)
  • eye_color (TEXT)
  • gender (TEXT)
  • plate_number (TEXT)

SQL Lessons

Achievements

First Query

Run your first SQL query

SQL Detective

Solve the murder mystery

SQL Master

Complete all 10 lessons

SQL Detective Console
Welcome to the SQL Detective console. Type your SQL queries below to investigate the murder.
Try: SELECT * FROM crime_scene_reports;
Need a hint? Click to expand

Investigation Tips:

  1. Start by examining the crime scene reports for January 15, 2024
  2. Look for witnesses who might have seen something suspicious
  3. Check who was at the gym on the day of the murder
  4. Match physical descriptions from witness statements
  5. Use JOIN statements to connect data from different tables

Introduction to SQL

Beginner

Try It Yourself

Write a SELECT statement to retrieve data from the database.

SELECT * FROM table_name;

Ready to Advance Your IT Career?

Master SQL and other essential IT skills with our comprehensive CompTIA exam simulators. Practice with realistic exam questions and boost your confidence for certification success.

CompTIA Exam Simulators Support Our Mission
© iTechVista. SQL Detective is a gamified learning tool for SQL and database concepts. All rights reserved.