SQL Challenges · THE GREAT DUCK MIGRATION!
Iron Duck Qualification
Difficulty: hard
Admiral Aqua unveils the prestigious Iron Duck competition framework with great ceremony. The ultimate test of migration readiness! The Iron Duck designation is reserved for our most versatile elite athletes - ducks who have not only competed in ALL four disciplines but achieved excellence in EACH one. We need athletes scoring 90 or above in swimming, running, diving, AND flying_speed. These complete athletes can handle any challenge the migration throws at us. Transform our performance data to…
Your task
Return the sum of SSNs for all ducks who qualify as Iron Ducks - athletes who have achieved a best score of 90 or higher in ALL four sports (swimming, running, diving, and flying_speed). Transform the data to compare each duck's best performance across all disciplines simultaneously. You will be working with `duck_athletes` and `performance_records` tables.