SQL Challenges · WEEKLY QUACK CHALLENGE!
DUCK OLYMPICS PHOTO FINISH
Difficulty: hard
Track Judge Pintail squints at the photo-finish screen. Everybody watched the leader at checkpoint three — but the real story is who flew past them at the tape! Some duck went from nearly last to first in the final stretch. Thats the comeback of the century, Duckbert. Dont look at the sprint — this is marathon business. Find the duck who improved their rank the most from the second-to-last checkpoint all the way to the finish!
Your task
Among marathon runners only, rank the field by time at each checkpoint (fastest is rank 1). The comeback of the day belongs to the runner who climbs the most ranks between the last checkpoint before the finish and the finish itself. Return their name; on a tie, the alphabetically first. You will be working with the `splits`, `athletes`, and `races` tables.