SQL Challenges · THE GREAT DUCK MIGRATION!
The Rising Star
Difficulty: 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!
Your 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 |
Database: https://dbquacks.com/data/databases/athletic_champions.duckdb
This page as markdown: https://dbquacks.com/challenges/athletic/7.md