# The Suspect Pool

THE CHRISTMAS HEIST! · challenge 2 · easy

> Detective Quacker looks up from the missing presents report with determination. "Now that we know the scope of this heist, we need to find who could access the warehouse. Not everyone could pull off this heist! The warehouse requires high-level access clearance. Find all volunteers with experience_level of 7 or higher - these ducks had the keys to everything. We need to know how many potential suspects we're dealing with!"

## Task

Count how many volunteers have an experience_level of 7 or higher. You will be working with the `volunteer_ducks` table.

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

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

## Answer

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