SQL Challenges · THE GREAT DUCK MIGRATION!
Speed Champions Registry
Difficulty: easy
Navigator Neptune swoops down with urgent weather reports and flight charts. Storm winds are intensifying to dangerous speeds! We need our fastest flying ducks to scout ahead and find calm air corridors through the turbulence. Find all ducks who have achieved a flying_speed score above 80.00 at any point - these speed champions can outfly the storm and guide others to safety. Sum their identification codes for the elite speed squadron registry!
Your task
Return the sum of SSNs for all ducks who have achieved a flying_speed score above 80.00 (count each duck only once, even if they have multiple qualifying scores). You will be working with the `duck_athletes` and `performance_records` tables to find high-performing flyers.