# The Iron Will Award

THE GREAT DUCK MIGRATION! · challenge 21 · easy

> Scout Samantha unfurls a worn scroll listing years of competition attendance records. "Dedication is the backbone of any successful migration! While raw talent matters, nothing replaces the grit and determination of showing up day after day, competition after competition. We need to identify the duck with the strongest iron will - the athlete who has entered more competitions than anyone else. This tireless competitor will carry our migration banner and set the pace when others want to give up. Their unwavering commitment to showing up is exactly what we need for the grueling journey ahead!"

## Task

Return the SSN of the duck who has participated in the most competitions overall. If there is a tie, return the duck with the smallest SSN. You will be working with the `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/21

## Answer

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