SQL Challenges · THE GREAT DUCK MIGRATION!
The Iron Will Award
Difficulty: easy
Scout Samantha unfurls a worn scroll listing years of competition attendance records. Dedication is the backbone of any successful migration! While raw talent matters, nothing replaces the grit and determination of showing up day after day, competition after competition. We need to identify the duck with the strongest iron will - the athlete who has entered more competitions than anyone else. This tireless competitor will carry our migration banner and set the pace when others want to give up.…
Your task
Return the SSN of the duck who has participated in the most competitions overall. If there is a tie, return the duck with the smallest SSN. You will be working with the `duck_athletes` and `performance_records` tables.