Fiftyville Theft Mystery

As Detective for the CS50 Fiftyville Mystery, I conducted a comprehensive SQL-based investigation to solve a complex theft case occurring on Humphrey Street Key Achievements: • Analyzed multiple interconnected database tables including witness testimonies, phone records, flight manifests, and security logs • Executed complex SQL queries with JOINs, subqueries, and conditional statements to cross-reference evidence • Successfully identified the thief, determined their escape destination, and uncovered their accomplice through systematic data analysis • Demonstrated logical deduction skills by connecting disparate clues across ATM transactions, bakery security footage, and courthouse records Skills: SQL, Database Analysis, Logical Reasoning, Problem-Solving, Data Investigation, SQLite