The Olympics dataset

Reporting in SQL

Tyler Pernes

Learning & Development Consultant

Entity-Relationship (E:R) diagram

Visual representation of database structure
Lays out tables and fields
Identifies relationships

Olympics dataset E:R diagram

SELECT *
FROM countries AS c1
JOIN country_stats AS c2
ON c1.id = c2.country_id;

Tables and fields

Reference for queries

SELECT 
    region, 
    SUM(pop_in_millions) AS pop_in_millions
FROM countries AS c1
JOIN country_stats AS c2
ON c1.id = c2.country_id
GROUP BY region;

Practice time!

Reporting in SQL