Interactive Lesson: SQL Rescue Quest

SQL Quest: Query Rescue Mission

⚡ SQL Quest ⚡

Query Rescue Mission: Save TechCorp’s Analytics!

📊 URGENT MISSION BRIEFING

TechCorp’s analytics pipeline is in crisis! Their queries are broken, slow, and producing wrong results. As an elite SQL consultant, you must debug, optimize, and rebuild their critical queries. Each level presents a different challenge testing your SQL mastery. Can you save their data before the quarterly review?

SQL Master Score
0 / 600
Points Earned
1
Fix Filters
2
Aggregation
3
Join Master
4
Window Pro
5
CTE Expert
6
Optimize!

🔧 Problem Analysis

Level 1: Broken Filter Query

The sales team’s query returns no results, but we know there should be data!

  • Find orders from January 2024
  • Only include ‘Shipped’ or ‘Delivered’ status
  • Amount must be over $100
  • Exclude test customers (email ends with @test.com)
💡 Hint:

Check your date format, operator precedence, data types, and LIKE pattern!

📊 Query Results

⚙️ Execution Output

Run your query to see results here…

Query Performance Score
0%

✅ Level Complete!

Excellent work! You’ve fixed the query!