SQL Mysteries
There's been a string of crimes in Void! Can you solve the crimes using your SQL knowledge?
We currently have a total of 29 cases that can be solved.
Directions
Use your SQL knowledge to solve the crimes by reading the information. All the clues to each case are within the interviews done by the officers on the scene. You should find the related data, sort through suspects, and find the perpetrator of the crime.
For security reasons, limitations are in place. The SQL language used is MySQL, and only select queries are allowed.
Current Case
Date: 2023-01-03
Report: Johnathan King hit a deer. While inspecting the damage, another vehicle clipped his truck.
When you've completed the case, you may use the button below to be assigned to a new case.
Database ERD
Find Clues
Use the new information you discover to make new queries.
Start by getting the interviews relating to the case by using the case information provided. Each case is unique and will have different clues provided.
Queries must end in a semi-colon to be valid.
Query Results
Previous Queries
Your Guess
When you think you have found the perpetrator, enter the perpetrator's perID below. The system will tell you if you are correct or not. Good Luck!
Feedback
Your guess results will display here!
When you've completed the case, you may use the button below to be assigned to a new case.