SQL Challenges · THE GREAT DUCK MIGRATION!
Consistent Excellence Search
Difficulty: medium
Scout Samantha arrives with endurance charts and reliability metrics. The migration isnt just about peak performance - its about unwavering consistency! Through storms, predators, and exhaustion, we need ducks who NEVER fail under pressure. Find all athletes who have NEVER scored below 70.00 in any competition ever. These steady, reliable performers will maintain perfect V-formation during the entire grueling 3,000-mile journey without faltering!
Your task
Return the sum of SSNs for all ducks who have never scored below 70.00 in any of their competitions (ducks with no performance records should not be included). You will be working with the `duck_athletes` and `performance_records` tables to find consistently excellent performers.
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/10.md