You are viewing a single comment's thread. Return to all comments →
the question says rounded down to the nearest integer.
So i think round() function should be used. Why using floor() clears TC??
SELECT country.continent, FLOOR(AVG(city.population)) FROM country INNER JOIN city ON city.countrycode = country.code GROUP BY country.continent;
Average Population of Each Continent
You are viewing a single comment's thread. Return to all comments →
the question says rounded down to the nearest integer.
So i think round() function should be used. Why using floor() clears TC??