# Multi-Checkpoint Access Patterns

THE CHRISTMAS HEIST! · challenge 10 · hard

> Detective Quacker reviews the evidence board. "So many deliveries by elite performers... but we still need to understand who had access to pull this off!" Maestro Maurice conducts with his baton over a swirling data symphony. "Detective! I've been analyzing those security checkpoint events Dr. Temporal provided. The advanced security system has FOUR checkpoint types: gate, door, badge_scan, and camera_detection. That's a lot of security events to analyze! We need to find volunteers who accessed ALL FOUR checkpoint types—only someone with complete facility access could orchestrate this operation. Among suspects with full access, who has the most total checkpoint events? Give me their name!"

## Task

Find the name of the volunteer who accessed all 4 checkpoint types (gate, door, badge_scan, camera_detection) AND has the most total checkpoint events. You will be working with `dbquacks_xmas.security_checkpoint_events` (MotherDuck) and `volunteer_ducks` (local) tables.

## Tables

### `volunteer_ducks` (50 rows)

| column | type |
| --- | --- |
| duck_id | INTEGER |
| name | VARCHAR |
| specialty | VARCHAR |
| shift_start | TIME |
| shift_end | TIME |
| experience_level | INTEGER |
| background_check_date | DATE |
| home_district | VARCHAR |

### `dbquacks_xmas.security_checkpoint_events`

A table in a MotherDuck share; its columns are not listed here.

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

This level also queries MotherDuck shares, which need a MotherDuck token. On the page, the editor asks for one.

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

## Answer

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