SQL Mysteries
03b7: ....There's been a string of crimes in Void! Can you solve th 03f7: e crimes using your SQL knowledge?
041f: ........We currently have a total of 20 cases that can 045f: be solved.
0470: ...Directions
04dd: ....Use your SQL knowledge to solve the crimes by reading the 051d: information. All the clues to each case are within the intervie 055d: ws done by the officers on the scene. You should find the relate 059d: d data, sort through suspects, and find the perpetrator of the c 05dd: rime.
05e8: ....For security reasons, limitations are in place. The SQL l 0628: anguage used is MySQL, and only select queries are allowed.
0669: ....Current Case
0684: ....Date: 2021-04-05
Report: A tan Honda Fit
06c4: with a license plate of "YVS 745" was recently stolen
0704: . The owner of the vehicle stepped forward to make a statement,
0744: and one witness, Mr. Luo, came forward who has seen someone else
0784: driving the vehicle.
079b:
When you've co 07db: mpleted the case, you may use the button below to be assigned to 081b: a new case.
082d: .... 0833: .... 0909: ...Database ERD
0954: ....
098a: ...Find Clues
09f9: ....
0a79: Use the new information you discover to make new queries.
0ab8: ....Start by getting the interviews relating to the case by usin
0af8: g the case information provided. Each case is unique and will ha
0b38: ve different clues provided.
Queries must end in a semi-co 0b78: lon to be valid.
0b8e: .... 0d23: .... 0d30: ...Query Results
0d92: ....
0d9e: ....
0dab: ....
0db8: ...Previous Queries
0e1c: ....< 0e5c: /p> 0e61: ...
Your Guess
0eca: ....When you think you have found the perpetrator, enter the 0f0a: perpetrator's perID below. The system will tell you if you are c 0f4a: orrect or not. Good Luck!
0f69: .... 114d: .... 115a: ...Feedback
11c1: ....
11cd: .....Your guess results will display here!....
1204: ....
1211: ....When you've completed the case, you may use 1251: the button below to be assigned to a new case.
1285: .... 135c: ...