課程資料網(wǎng)盤鏈接：https://pan.baidu.com/s/1-jOwaXWArtv8h21B0-uWGg 提取碼：wsra
SQL零基礎(chǔ)入門筆記：https://www.mubucm.com/doc/4VC7JuHlj6H
云端數(shù)據(jù)庫(kù)安裝文檔：https://share.mubu.com/doc/rBUGcUie8H
Python安裝文檔：https://www.mubucm.com/doc/4DJ8YNSNz4F
select continent from world group by continent having sum(population)>=100000000
image.png
select continent, avg(gdp) 平均gdp
from world
where (gdp>20000000000
and population > 60000000)
or (gdp < 8000000000
and capital like '%a%a%a%')
group by continent having sum(population)>=300000000
order by count(name) desc
limit 1
image.png
