# Age Division Protocol

THE GREAT DUCK MIGRATION! · challenge 14 · medium

> Coach Waddles gathers everyone for formation assignments. "Age matters for migration survival! Juniors (under 5) need protection in the center. Prime athletes (5-7) fly in formation wings. Veterans (8+) lead with experience. Find all Prime-age athletes - they'll form our powerful outer formations for maximum flock protection!"

## Task

Return the sum of SSNs for all athletes in the "Prime" age category (age 5, 6, or 7). You will be working with the `duck_athletes` table to categorize athletes by age groups.

## Tables

### `duck_athletes` (50 rows)

| column | type |
| --- | --- |
| id | BIGINT |
| ssn | BIGINT |
| name | VARCHAR |
| age | BIGINT |
| hometown | VARCHAR |

## Data

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

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

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

Play it in the browser: https://dbquacks.com/challenges/athletic/14

## Answer

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