# Migration Team Assembly

THE GREAT DUCK MIGRATION! · challenge 2 · easy

> Coach Waddles hurries over with a training schedule. "Great choice on the scout! Now we need to know exactly how many elite athletes participated in 2025 competitions. The migration team needs precise size estimates for formation planning. Count each duck once, regardless of how many different sports they attempted!"

## Task

Return the total number of different ducks who competed in any sport during the year 2025. You will be working with the `performance_records` table to count unique athletes who competed in 2025. 

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

## Answer

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