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.
Average Population of Each Continent
Average Population of Each Continent
Sort by
recency
|
1563 Discussions
|
Please Login in order to post a comment
Can someone tell me what is wrong in the below query.
select COUNTRY.Continent , FLOOR(AVG(CITY.POPULATION)) from CITY right join COUNTRY on CITY.CountryCode = COUNTRY.Code group by COUNTRY.Continent
select COUNTRY.Continent , floor(avg(CITY.Population)) from COUNTRY inner join CITY on COUNTRY.Code = CITY.CountryCode group by COUNTRY.Continent
MySQL: select country.continent, floor(avg(city.population)) from city inner join country on city.countrycode = country.code group by country.continent
Select COUNTRY.Continent, FLOOR(AVG(CITY.POPULATION)) from COUNTRY INNER JOIN CITY ON COUNTRY.Code = CITY.CountryCode GROUP BY COUNTRY.Continent;