Consider the table named COUNTRIES:

Determine the average population on each continent.

Question

Consider the table named COUNTRIES: 
  
 Determine the average population on each continent.

Answer

SELECT COUNTRY, AVG(POPULATION) 
 FROM COUNTRIES 
 GROUP BY COUNTRY

Answer

SELECT CONTINENT, COUNTRY, AVG(POPULATION) 
 FROM COUNTRIES 
 GROUP BY CONTINENT, COUNTRY

Answer

SELECT AVG(POPULATION) 
 FROM COUNTRIES

Answer

SELECT CONTINENT, AVG(POPULATION) 
 FROM COUNTRIES 
 GROUP BY CONTINENT

Answer

SELECT CONTINENT, COUNTRY, AVG(POPULATION) 
 FROM COUNTRIES 
 GROUP BY CONTINENT

Crowdly