# Elite Squadron Assembly

THE GREAT DUCK MIGRATION! · challenge 19 · hard

> Professor Shellbert calls an urgent leadership meeting. All team leaders gather - Coach Waddles, Dr. Stork, General Gander, Captain Cosmos, Navigator Neptune, Scout Samantha, and Admiral Aqua. "We're forming an elite strike squadron! We need Prime-age athletes (5-7) who ranked in the top 3 for their sport in 2025 AND maintained consistency by never scoring below 50. Find these exceptional few!"

## Task

Return the sum of SSNs for ducks aged 5-7 who achieved a dense rank of 1, 2, or 3 in at least one sport during 2025 (ranking within each sport separately, based on best 2025 score in that sport) AND have never scored below 50.00 in any competition ever. You will be working with `duck_athletes` and `performance_records` tables.

## Tables

### `performance_records` (800 rows)

| column | type |
| --- | --- |
| duck_id | BIGINT |
| sport | VARCHAR |
| score | DOUBLE |
| competition_date | DATE |

### `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/19

## Answer

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