🔍 Cases

🕵️ About Query the Murder 🔪

👋 Welcome, Detective!

So you want to be the next Hercule Poirot? Well, grab your magnifying glass and your SQL cheatsheet because at Query the Murder, we solve murders the nerdy way—with databases! 💻🔎

🎯 What is Query the Murder?

Query the Murder is where classic Agatha Christie mysteries meet SQL queries. Instead of dusty old clues and dramatic confrontations in the drawing room, you'll be writing SELECT statements, JOINs and window functions to crack the case. Think of it as CSI: Database Edition! 🧪📊

Each case is based on a real Agatha Christie novel, with suspects, alibis, events and motives all stored in a PostgreSQL database. Your job? Query your way to the truth!

💡 How do the cases work?

Each case has 5 questions that guide you through the investigation:

  1. Q1: Meet the suspects (simple intro query)
  2. Q2-Q4: Dig into alibis, motives, timelines, evidence
  3. Q5: Reveal the killer! 🎉 (with confetti!)

The questions get progressively harder, building on SQL concepts as you go. It's like a murder mystery and a SQL bootcamp had a baby! 👶💾

🛠️ Your Detective Tools

🗄️ Table Information Button: Click this sidebar icon to see all database tables and columns. No more guessing if it's suspect_name or suspectName!

🔑 Reveal Answer Button: Stuck? Can't figure out why your query returns 0 rows? Hit this to see the correct SQL query. No judgment—even Poirot needs hints! 🤫

✨ Real-time Feedback: Submit your query and instantly see if you've cracked the case or if you're chasing red herrings!

🎓 Who Is This For? Do I need advanced SQL?

  • 📚 Students learning SQL in a fun way
  • 💼 Data analysts brushing up on their skills
  • 🧠 Mystery lovers who want to flex their logical thinking
  • 🤓 Anyone who thinks databases are cool (yes, we exist!)

No advanced SQL required. Cases start beginner-friendly and get harder as you go. If you get stuck, you can use table schemas and Reveal Answer to learn the right approach.

⚠️ SPOILER ALERT! ⚠️

🚨📢🔴

HOLD UP, DETECTIVE!

If you haven't read these Agatha Christie novels yet and don't want to know who the killer is, TURN BACK NOW! 🏃‍♂️💨

Question 5 of each case WILL REVEAL THE ACTUAL KILLER FROM THE BOOK. We're talking full-on, case-closed, whodunit spoilers! We're here to teach SQL, not ruin your book club discussions. You've been warned! 📚🔪