De Olympics-dataset

Rapporteren in SQL

Tyler Pernes

Learning & Development Consultant

Entity-Relationship (E:R)-diagram

Visuele weergave van de databasestructuur
Toont tabellen en velden
Geeft relaties aan

E:R-diagram van de Olympics-dataset

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

Tabellen en velden

Referentie voor 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;

Laten we oefenen!

Rapporteren in SQL