The CS50 Duck has been stolen! The town of Fiftyville has called upon you to solve the mystery of the stolen duck. Authorities believe that the thief stole the duck and then, shortly afterwards, took a flight out of town with the help of an accomplice. Your goal is to identify:
- Who the thief is,
- What city the thief escaped to, and
- Who the thief accomplice is who helped them escape
What is SQL?
SQL stands for Structured Query Language. It lets you access and manipulate databases
and became a standard of the American National Standards Institute (ANSI) in 1986,
and of the International Organization for Standardization (ISO) in 1987.
Some useful SQL Introduction for beginner.
SQL Keyword reference for some helpful syntax.
How to solve the mystery?
All you know is that the theft took place on July 28, 2021 and that it took place on Humphrey Street.
Use SQL command to query through the database to find the information you need and finally solving the mysteries.
Lets start right away
Enter the SQL command inside the textarea. The default command would show the schema for the database. Use execute button to
run the command and Reset button to show the schema command.
PS: You can run multiple SQL command by seperating each command with semicolon.
Results will be displayed here
Checking the answer
Input your answer and check whether you capture the right guy or not. Figured the accomplice and
manage to determine where the culprit escape city is.
Side Note: The image response gonna take some time to process. Do give it sometime. Be mindful with the Upper and lowercase.
