SQL Challenges · THE GREAT DUCK MIGRATION!
Hall of Champions
Difficulty: hard
Professor Shellbert unveils the ancient Hall of Champions scroll with golden seals. Every migration needs specialist elite guards! Find all ducks who hold the all-time highest score in any sport - these record holders have unmatched skills. Theyll protect our flock from sky predators, navigate through storms, and lead specialized formations. Sum their identification codes for the registry!
Your task
Return the sum of SSNs for all ducks who have the all-time highest score in at least one sport (count each duck only once, must be top scorer in their respective sport). You will be working with the `duck_athletes` and `performance_records` tables to assemble the elite guard of record holders.