We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Basic Join
  4. Average Population of Each Continent
  5. Discussions

Average Population of Each Continent

  • SVVBathini_w
     + 0 comments

    For MySQL Platform

    The given answer is wrong. Actually we need to use the ROUND function since it's mentioned to round down to nearest integer. I used FLOOR function just to match the answer

    SELECT country.continent, FLOOR(AVG(city.population)) FROM country
JOIN city ON country.code = city.countrycode
GROUP BY 1;