SQL Challenges · THE CHRISTMAS HEIST!
The Missing Presents Report
Difficulty: easy
Detective Quacker paddles urgently into the station, with a magnifying glass in his wing. Duckbert! We have a crisis — families across Pondville are reporting missing Christmas presents! Before we chase suspects, I need the basic facts. How many total presents are reported missing? Count every stolen gift so we understand the scope of this heist!
Your task
Return the total number of missing presents from all reports. You will be working with the `missing_presents_report` table.
Tables
missing_presents_report (93 rows)
| column | type |
|---|---|
report_id | INTEGER |
household_id | INTEGER |
present_id | INTEGER |
reported_date | TIMESTAMP |
quantity_missing | INTEGER |
last_seen_location | VARCHAR |
reporter_name | VARCHAR |
Database: https://dbquacks.com/data/databases/christmas_local.duckdb
This page as markdown: https://dbquacks.com/challenges/christmas/1.md