Consider the table named COUNTRIES

The following query:
SELECT CONTINENT, COUNT(COUNTRY)
FROM COUNTRIES
GROUP BY CONTINENT
HAVING SUM(POPULATION) 300
would give us the information about:

Question

Consider the table named COUNTRIES 
  
 The following query: 
 SELECT CONTINENT, COUNT(COUNTRY) 
 FROM COUNTRIES 
 GROUP BY CONTINENT 
 HAVING SUM(POPULATION) > 300 
 would give us the information about:

Answer

The count of countries on each continent

Answer

Continents with population exceeding 300 million,along with the respective count of countries

Answer

Continents with population exceeding 300 million

Answer

Information sorted by the population

Answer

Total population on each continent

Crowdly

Consider the table named COUNTRIES The following query: SELECT CONTINENT,...

Want instant access to all verified answers on softserve.academy?