奥运会数据集

SQL 报表制作

Tyler Pernes

Learning & Development Consultant

实体-关系（E:R）图

数据库结构的可视化
展示表与字段
标示关系

奥运会数据集 E:R 图

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

表与字段

查询参考

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;

¡Vamos a practicar!

SQL 报表制作