# The Rising Star

THE GREAT DUCK MIGRATION! · challenge 7 · hard

> Migration day dawns! Dr. Stork returns with the final selection tablet. "One last crucial role - our inspiration symbol! Find the duck with the biggest improvement from 2024 to 2025. This rising star will motivate others during the hardest parts of our journey. Their growth gives everyone hope!"

## Task

Return the SSN of the duck with the largest improvement from their best 2024 score to their best 2025 score in the same sport. You will be working with the `duck_athletes` and `performance_records` tables to find the most improved rising star.

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

## Answer

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