SQLZOO: SUM and COUNT/zh & The nobel table can be used to practice more SUM and COUNT functions./zh

8. 列出有至少100百萬(1億)(100,000,000)人口的洲份。

select distinct(continent)
from world x
where 100000000<=(select sum(population) from world y where x.continent=y.continent)

9. 列出哪年曾同年有3個物理獎Physics得獎者。

select yr
from nobel
where subject ='physics'
group by yr
having count(winner)=3