# The Perfect Score Archive

THE GREAT DUCK MIGRATION! · challenge 20 · easy

> Professor Shellbert carefully opens the ancient Hall of Legends vault, dust swirling in the morning light. "Before every great migration, we honor those who have touched perfection! A score of 105 represents the absolute pinnacle - the theoretical maximum that accounts for flawless technique, perfect conditions, and that indescribable spark of greatness. These legendary performances are etched into our historical archives forever. Find all ducks who have achieved this mythical score at least once in their career - they carry the spirit of excellence that will inspire our entire flock through the darkest storms ahead!"

## Task

Return the sum of SSNs for all ducks who have achieved a perfect score of exactly 105 in any competition. Count each duck only once, even if they achieved multiple perfect scores. 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/20

## Answer

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