Consider the table named COUNTRIES:

Determinethe count of countries for each continent

Question

Consider the table named COUNTRIES: 
  
 Determinethe count of countries for each continent

Answer

SELECT CONTINENT, COUNT(COUNTRY) 
 FROM COUNTRIES

Answer

SELECT COUNT(COUNTRY) 
 FROM COUNTRIES

Answer

SELECT COUNTRY, COUNT(COTINENT) 
 FROM COUNTRIES 
 GROUP BY COUNTRY

Answer

SELECT CONTINENT, COUNT(COUNTRY) 
 FROM COUNTRIES 
 GROUP BY CONTINENT

Answer

SELECT * 
 FROM COUNTRIES 
 HAVING COUNT(COUNTRY)

Crowdly