# Speed Champions Registry

THE GREAT DUCK MIGRATION! · challenge 9 · easy

> Navigator Neptune swoops down with urgent weather reports and flight charts. "Storm winds are intensifying to dangerous speeds! We need our fastest flying ducks to scout ahead and find calm air corridors through the turbulence. Find all ducks who have achieved a flying_speed score above 80.00 at any point - these speed champions can outfly the storm and guide others to safety. Sum their identification codes for the elite speed squadron registry!"

## Task

Return the sum of SSNs for all ducks who have achieved a flying_speed score above 80.00 (count each duck only once, even if they have multiple qualifying scores). You will be working with the `duck_athletes` and `performance_records` tables to find high-performing flyers.

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

## Answer

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