SQL Challenges · THE GREAT DUCK MIGRATION!
Elite Tier Ranking
Difficulty: hard
Captain Cosmos descends with holographic formation displays. Space-age formation strategy requires precision tiering! Rank all 2025 swimming performances into skill tiers using dense ranking - no gaps in rankings even with tied scores. Find athletes in the elite top tier (rank 1 or 2) who will lead our water crossings!
Your task
Return the sum of SSNs for all ducks who achieved a dense rank of 1 or 2 based on their best swimming score in 2025. Use SQL's DENSE_RANK() function where tied scores receive the same rank with no gaps. 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/18.md