🔍 SQL Detective: Warehouse Edition

Uncover the truth hidden in the data warehouse

Investigation Progress Score: 0
0%

📊 Case File: The Quarterly Collapse

Date: Q4 2024 | Company: TechMart Corporation

TechMart's profits have mysteriously plummeted by 40% this quarter. The CEO suspects internal fraud, supply chain issues, or a major product problem. Your mission: analyze the data warehouse to uncover what really happened.

Complete all 5 SQL challenges to reveal the truth. Each correct query unlocks a crucial clue!

Clue #1
???
Clue #2
???
Clue #3
???
Clue #4
???
Clue #5
???

📁 Data Warehouse Schema

fact_sales
sale_id, product_id, customer_id, date_id, store_id, quantity, revenue, discount_amount, return_flag
dim_product
product_id, product_name, category, subcategory, supplier_id, unit_cost, launch_date
dim_date
date_id, date, year, quarter, month, week, day_of_week, is_holiday
dim_customer
customer_id, customer_name, segment, region, join_date, lifetime_value
dim_store
store_id, store_name, region, store_type, manager_id, opened_date
fact_inventory
snapshot_date, product_id, store_id, quantity_on_hand, quantity_on_order, stockout_flag
Challenge 1 of 5: Loading...
Hint:
Loading challenge...
🎓 Expert SQL Consultant
💡 Learning Tip: Try typing this query yourself instead of copy-pasting. It helps build muscle memory for SQL syntax!