SQL Challenges · THE GREAT DUCK MIGRATION!
Career Regression Alert
Difficulty: hard
Coach Waddles spreads out career trajectory charts with deep worry lines across his feathered brow. The migration medics need an urgent report! Were tracking athletes whose journey has taken a concerning turn - ducks whose most recent performance in a sport has dropped significantly below their debut performance. A decline of 20 points or more from first attempt to latest attempt signals potential burnout, injury, or loss of confidence. These athletes need immediate intervention and support bef…
Your task
Return the sum of SSNs for all ducks who have experienced significant performance regression - where their latest score in any sport is at least 20 points lower than their debut score in that same sport (comparing their first competition to their most recent competition within each sport). Count each duck only once even if they regressed in multiple sports. You will be working with `duck_athletes` and `performance_records` tables.