Exploration of the Knight Lab SQL Murder Mystery challenge, solving a crime-themed relational database puzzle through query logic, joins, and data investigation.
This project documents my solution to the Knight Lab SQL Murder Mystery, a puzzle‑style SQL challenge where players use relational queries to solve a fictional crime. The exercise provided hands-on practice with query design, filtering, joins, and investigative reasoning in a relational database context.
- Practice SQL query logic in a mystery-themed challenge.
- Apply filtering, joins, and aggregation to extract insights.
- Translate narrative clues into structured database queries.
- Strengthen problem-solving and investigative reasoning with SQL.
- Reviewed the provided schema and available tables.
- Translated narrative clues into SQL queries.
- Iteratively joined and filtered data to narrow down suspects.
- Validated results against the challenge’s solution checker.
- Identified both the immediate perpetrator and the mastermind.
- Reinforced SQL fundamentals in a playful and interactive manner.
- Practiced translating ambiguous, text-based requirements into structured queries.
- GBuilt confidence in iterative problem‑solving with relational databases.