SQL Challenges · THE GREAT DUCK MIGRATION!
Migration Leader Selection
Difficulty: hard
Goose Gordon arrives with the golden migration compass and ceremonial staff. Time to choose our overall migration leader! We need the duck with the best average performance in 2025 - theyll guide thousands through perilous skies. Remember: when ducks attempted sports multiple times, use only their best score. Excellence under pressure determines survival!
Your task
Return the SSN of the duck with the highest average score in 2025 (using their best score per sport). You will be working with the `duck_athletes` and `performance_records` tables to find the ultimate migration leader.