SQL Challenges · THE GREAT DUCK MIGRATION!
Weekend Warriors
Difficulty: medium
Captain Cosmos descends with astronomical charts and competition scheduling records. The weekend warriors hold a special place in migration lore! While most ducks rest on Saturdays and Sundays, some dedicated athletes sacrifice their leisure time to compete when others are lounging by the pond. These weekend competitors demonstrate exceptional commitment - they train during the week AND compete when they could be relaxing. Find all ducks who have entered at least one competition on a Saturday o…
Your task
Return the sum of SSNs for all ducks who have competed in at least one competition held on a weekend (Saturday or Sunday). Count each duck only once regardless of how many weekend competitions they entered. You will be working with the `duck_athletes` and `performance_records` tables.