# The Missing Presents Report

THE CHRISTMAS HEIST! · challenge 1 · 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!"

## 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 |

## Data

The tables live in a DuckDB database: https://dbquacks.com/data/databases/christmas_local.duckdb

To query it outside the browser, attach it read-only:

```sql
ATTACH 'https://dbquacks.com/data/databases/christmas_local.duckdb' AS db (READ_ONLY);
USE db;
```

Play it in the browser: https://dbquacks.com/challenges/christmas/1

## Answer

The expected answer is not published. Submit on the page to have it checked.