SQL Challenges · THE GREAT DUCK MIGRATION!
Peak Performance Season
Difficulty: medium
Navigator Neptune reviews years of weather and performance data. Migration timing is critical for success! Historical competition data shows that athletes perform differently throughout the year - some months bring out peak performance while others see declines. Analyze all competitions across all years and identify which month of the year produces the highest average scores. This insight will help us schedule future training camps during optimal conditions!
Your task
Return the full name of the month (e.g., 'January', 'February') that has the highest average competition score across all years and all sports. If multiple months tie for the highest average, return the one that comes first alphabetically. You will be working with the `performance_records` table. Use MONTHNAME function to get the month name.
Tables
performance_records (800 rows)
| column | type |
|---|---|
duck_id | BIGINT |
sport | VARCHAR |
score | DOUBLE |
competition_date | DATE |
Database: https://dbquacks.com/data/databases/athletic_champions.duckdb
This page as markdown: https://dbquacks.com/challenges/athletic/28.md