Dataset Olimpiade

Pelaporan dengan SQL

Tyler Pernes

Learning & Development Consultant

Diagram Entity-Relationship (E:R)

Representasi visual struktur basis data
Menyusun tabel dan field
Mengidentifikasi relasi

Diagram E:R dataset Olimpiade

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

Tabel dan field

Referensi untuk query

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;

Ayo berlatih!

Pelaporan dengan SQL