2. Counting rows

SELECT COUNT(*) AS "Number of Country"

FROM Country

WHERE POPULATION > 100000000

AND Continent = "Asia";

SELECT Continent, COUNT(Name) AS "Number of Country"

FROM Country

WHERE Population > 5000000

AND LifeExpectancy > 70.0

GROUP BY Continent

ORDER BY COUNT(Name) ASC;