SQL Challenges · THE GREAT DUCK MIGRATION!
Formation Flying Prep
Difficulty: medium
Captain Cosmos appears with flight pattern diagrams and tactical charts. Formation flying requires perfect coordination! Which sport attracted the most athletes in 2024? The most practiced skill will determine our V-formation strategy for the dangerous journey ahead. If theres a tie, choose alphabetically - we need military precision for this migration!
Your task
Return the name of the sport that had the most different athletes competing in 2024. If there's a tie, return the sport that comes first alphabetically. You will be working with the `performance_records` table to find the most popular sport in 2024.
Tables
performance_records (800 rows)
| column | type |
|---|---|
duck_id | BIGINT |
sport | VARCHAR |
score | DOUBLE |
competition_date | DATE |
duck_athletes (50 rows)
| column | type |
|---|---|
id | BIGINT |
ssn | BIGINT |
name | VARCHAR |
age | BIGINT |
hometown | VARCHAR |
Database: https://dbquacks.com/data/databases/athletic_champions.duckdb
This page as markdown: https://dbquacks.com/challenges/athletic/3.md