HackerRank[MySQL] : Average Population of Each Continent

Average Population of Each Continent

Q

# FLOOR
SELECT COUNTRY.CONTINENT, FLOOR(AVG(CITY.POPULATION))
FROM CITY JOIN COUNTRY ON COUNTRY.CODE = CITY.COUNTRYCODE
GROUP BY CONTINENT

# TRUNCATE 
SELECT COUNTRY.CONTINENT, TRUNCATE(AVG(CITY.POPULATION),0)
FROM COUNTRY
JOIN CITY
ON COUNTRY.CODE = CITY.COUNTRYCODE
GROUP BY COUNTRY.CONTINENT;

# ROUND
SELECT COUNTRY.CONTINENT, ROUND(AVG(CITY.POPULATION)-0.5)
FROM CITY JOIN COUNTRY ON COUNTRY.CODE = CITY.COUNTRYCODE
GROUP BY CONTINENT