# The Great Migration Scout

THE GREAT DUCK MIGRATION! · challenge 1 · easy

> Professor Shellbert paddles over urgently with migration maps. "Duckbert! The Great Migration approaches and river crossings are treacherous this year! We need our strongest swimmer to scout dangerous waters ahead. Find the duck with the highest swimming score ever recorded - they'll lead us safely across the rapids and whirlpools!"

## Task

Return the SSN of the duck with the highest swimming score in our database. In case of a tie for best performance, return the duck whose best performance was most recent. You will be working with the `duck_athletes` and `performance_records` tables to find the strongest swimmer.

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

## Answer

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