why is my query not working?

select country.continent , round(avg(city.population),0) from country join city on city.countrycode = country.code group by country.continent;