Winter Olympics SQL Playground

This playground contains official results from four Winter Olympic Games, covering thousands of athletes, hundreds of events, and dozens of countries. Your mission: navigate this complex data structure, write smart queries, and uncover the real stories hidden in the numbers.


Database Tables

The playground uses a normalized relational database with four interconnected tables:

  • athletesPhysical profiles of every athlete who competed
  • teamsMaps team identifiers to countries
  • gamesReference table for each Winter Olympics
  • resultsThe fact table - every row represents one athlete's participation in one event

See the Tables tab for detailed schema information.


Ready to Begin?

You can dive in and explore the data yourself, follow a guided investigation in our Tutorial, or work your way through the Challenges to practice advanced SQL techniques.

Tables:
athletesteamsgamesresults
PostgreSQL 14