SQL Challenges · THE GREAT DUCK MIGRATION!
Migration Team Assembly
Difficulty: easy
Coach Waddles hurries over with a training schedule. Great choice on the scout! Now we need to know exactly how many elite athletes participated in 2025 competitions. The migration team needs precise size estimates for formation planning. Count each duck once, regardless of how many different sports they attempted!
Your task
Return the total number of different ducks who competed in any sport during the year 2025. You will be working with the `performance_records` table to count unique athletes who competed in 2025.
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/2.md