SQL Challenges · THE GREAT DUCK MIGRATION!
Versatile Victory Formation
Difficulty: hard
Admiral Aqua glides in with the final mission briefing. The ultimate migration challenge requires versatility! Find all ducks who competed in at least 2 different sports AND achieved a score of 85 or higher in each sport type they attempted. These versatile champions can adapt to any situation - from swimming through floods to flying through storms. Their combined skills will ensure no obstacle stops our journey!
Your task
Return the sum of SSNs for all ducks who competed in 2+ different sports and whose best score in EVERY sport they have attempted is 85 or higher. You will be working with the `duck_athletes` and `performance_records` tables to find versatile high performers.