SQL Challenges · THE GREAT DUCK MIGRATION!
Veteran Navigator Search
Difficulty: medium
Dr. Stork approaches with ancient migration scrolls and historical records. Experience saves lives during dangerous migrations! We need proven veterans - ducks who competed in the same sport across multiple years show dedication and consistency. Their reliability under pressure will guide younger ducks through storms and predator territories. Find our most dedicated multi-year athletes!
Your task
Return the sum of SSNs for all ducks who competed in the same sport across 2 or more different years. You will be working with the `duck_athletes` and `performance_records` tables to find experienced multi-year athletes.
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/4.md