🕵️ SQL Noir: Case Archives

Welcome, detective.
This repository is your case vault — a collection of solved mysteries from the world of SQL Noir.

Each folder is a case file, packed with witness statements, crime scene evidence, and the SQL queries that cracked the mystery wide open.

---

📂 Case Files

Beginner Cases

1. Case File 1 - The Vanishing Briefcase (XP: 50) Case File 1 - The Vanishing Briefcase A briefcase vanished from the Blue Note Lounge. Last seen with a man in a trench coat.

2. Case File 2 - The Stolen Sound (XP: 100) Case File 2 - The Stolen Sound A prized vinyl record was stolen from West Hollywood Records. Find the thief before the music dies.

---

Intermediate Cases

1. Case File 3 - The Miami Marina Murder (XP: 200) Case File 3 - The Miami Marina Murder A body washes up at Coral Bay Marina. Two suspects. One killer. Justice awaits.

2. Case File 6 - The Vanishing Diamond (XP: 250) Case File 6 - The Vanishing Diamond The “Heart of Atlantis” necklace disappears mid-gala. High society hides deep secrets.

---

Advanced Cases

1. Case File 4 - The Midnight Masquerade Murder (XP: 300) Case File 4 - The Midnight Masquerade Murder A masked ball at Coconut Grove ends in murder. Behind the mask lies the truth.

2. Case File 5 - The Silicon Sabotage (XP: 1000) Case File 5 - The Silicon Sabotage Miami’s tech giant was ready to unveil groundbreaking innovation… until sabotage struck.

---

🗂️ What’s Inside Each Case

• README.md: The case brief and objectives
• solution.sql: A series of revealing queries that unravel the mystery step-by-step

---

🎯 Mission

Crack every case. Sharpen your SQL. Become the detective every dataset fears.

---

🕶️ "In the shadows of the database, every row has a secret… and every query brings you closer to the truth."