SQL Challenges · THE GREAT DUCK MIGRATION!
The Perfect Score Archive
Difficulty: easy
Professor Shellbert carefully opens the ancient Hall of Legends vault, dust swirling in the morning light. Before every great migration, we honor those who have touched perfection! A score of 105 represents the absolute pinnacle - the theoretical maximum that accounts for flawless technique, perfect conditions, and that indescribable spark of greatness. These legendary performances are etched into our historical archives forever. Find all ducks who have achieved this mythical score at least onc…
Your task
Return the sum of SSNs for all ducks who have achieved a perfect score of exactly 105 in any competition. Count each duck only once, even if they achieved multiple perfect scores. You will be working with the `duck_athletes` and `performance_records` tables.
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/20.md