coders.sh *

Loading Developers Heaven

The Ghost of 2020

Mission brief

Challenge Briefing

Easy

SELECT
WHERE
Filtering

A database migration for a major sports news site accidentally wiped out the historical winners' cache. Frantic journalists are calling for the 2020 FIFA Club World Cup winner. Your task is to query the core tournaments table and retrieve the single winner for that specific year.

The Ghost of 2020

Recover the missing name of the 2020 FIFA Club World Cup winner.

The Narrative

Schema Diagram

tournaments

idINT

yearINT

winnerVARCHAR

Challenge a Friend

One SQL table. One SQL condition.
Still tricky for most developers.

SQL Editor

Terminal Output

Initializing Database Engine v1.8.0...

Write a SQL query, then click Run Query

Keep practicing

Try another challenge

Similar difficulty and topics — pick up where you left off or stretch your SQL skills.

View all

Title	Complexity	Status	Solve
Git Blame Detective	Medium	Not solved	Solve
Deadlock Recovery	Easy	Not solved	Solve
Zombie Accounts	Medium	Not solved	Solve