SQL Challenges · THE GREAT DUCK MIGRATION!
Recovery Watch Protocol
Difficulty: hard
Dr. Stork rushes in with medical charts and performance tracking data. Emergency health protocol activated! Some athletes push too hard and suffer sudden performance drops - injuries, exhaustion, or overtraining syndrome. I need to identify the duck with the biggest score decline between consecutive attempts in the same sport. This pattern indicates potential health issues requiring immediate intervention. Their recovery is crucial before the migration - no duck gets left behind due to preventa…
Your task
Return the SSN of the duck with the largest negative performance change between consecutive competitions in the same sport. In case of a tie for the largest drop, return the duck with the smallest SSN. You will be working with the `duck_athletes` and `performance_records` tables to analyze consecutive performance changes.