Fiftyville mystery is a creative problem to learn & practice SQLite. Some clues to solve the problem have been given and you must use them along with you SQLite skills to solve the mystery.
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’s accomplice is who helped them escape
All you know is that the theft took place on July 28, 2021 and that it took place on Humphrey Street.
How will you go about solving this mystery? The Fiftyville authorities have taken some of the town’s records from around the time of the theft and prepared a SQLite database for you, fiftyville.db, which contains tables of data from around the town. You can query that table using SQL SELECT queries to access the data of interest to you. Using just the information in the database, your task is to solve the mystery.
The complete solution to solving this mystery is provided in log.sql and the final answers in answers.txt
- Problem statement creator: Staff of CS50x from Harvard University
- Creator of solution: @dampdigits