SQL Challenges · THE GREAT DUCK MIGRATION!
Hometown Pride Count
Difficulty: easy
Mayor Mallory waddles over with the town census and ceremonial scrolls. Pondville has always been the heart of athletic excellence since our founding! Before we depart on this perilous migration, we must honor our local champions properly. Sum the identification codes of all athletes from Pondville in our elite roster - their hometown needs to prepare the right hero medals and arrange the farewell parade before the great journey begins!
Your task
Return the sum of SSNs for all ducks from Pondville in the athletes registry. You will be working with the `duck_athletes` table to sum hometown representation.