SQL Challenges · THE GREAT DUCK MIGRATION!
Regional Excellence Analysis
Difficulty: medium
Mayor Mallory arrives with regional census data and athletic performance charts from every township in the land. Inter-regional pride is at stake! Every hometown claims to produce the best athletes, but we need DATA to settle this debate once and for all. Analyze all competition performances and determine which hometowns athletes achieve the highest average scores. This winning region will lead our migration departure ceremony with their banner held high! Consider every competition entry from e…
Your task
Return the name of the hometown whose athletes have achieved the highest average score across all their competition entries. Consider all performances from all ducks from each hometown. You will be working with the `duck_athletes` and `performance_records` tables.