SQL Challenges · THE GREAT DUCK MIGRATION!
The Great Migration Scout
Difficulty: easy
Professor Shellbert paddles over urgently with migration maps. Duckbert! The Great Migration approaches and river crossings are treacherous this year! We need our strongest swimmer to scout dangerous waters ahead. Find the duck with the highest swimming score ever recorded - theyll lead us safely across the rapids and whirlpools!
Your task
Return the SSN of the duck with the highest swimming score in our database. In case of a tie for best performance, return the duck whose best performance was most recent. You will be working with the `duck_athletes` and `performance_records` tables to find the strongest swimmer.
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/1.md