SQL Challenges · THE GREAT DUCK MIGRATION!
Elite Squadron Assembly
Difficulty: hard
Professor Shellbert calls an urgent leadership meeting. All team leaders gather - Coach Waddles, Dr. Stork, General Gander, Captain Cosmos, Navigator Neptune, Scout Samantha, and Admiral Aqua. Were forming an elite strike squadron! We need Prime-age athletes (5-7) who ranked in the top 3 for their sport in 2025 AND maintained consistency by never scoring below 50. Find these exceptional few!
Your task
Return the sum of SSNs for ducks aged 5-7 who achieved a dense rank of 1, 2, or 3 in at least one sport during 2025 (ranking within each sport separately, based on best 2025 score in that sport) AND have never scored below 50.00 in any competition ever. You will be working with `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 |
Database: https://dbquacks.com/data/databases/athletic_champions.duckdb
This page as markdown: https://dbquacks.com/challenges/athletic/19.md