Average Population of Each Continent

  • + 2 comments

    Can anyone please help me why I am am getting error with the below sql query for Oracle : select COUNTRY.CONTINENT,ROUND(AVG(COUNTRY.POPULATION),0) from CITY inner join on COUNTRY where CITY.COUNTRYCODE = COUNTRY.CODE;