Query the average population for all cities in CITY, rounded down to the nearest integer.

Query the average population for all cities in CITY, rounded down to the nearest integer.Input FormatThe CITY table is described as follows: MySQL1select ceil(avg(population)) from city group by ID;Line: 1 Col: 12Run Code Submit CodeUpload Code as FileWrong Answer :(1/1 test case failedSample Test case 0Compiler MessageWrong AnswerYour Output (stdout)59332113562113140321092361003993000004703954201360139389961402523869323242326101295124300197408143726135825125244118080111866945261191043940968972328985225731520944216247214288910707817962689442428980028120001565800530000195485189293169400136811120000118858102384273140131717131097125997124116116178850000435964927003900581714951591039973486001019841376001860761024344000059951535900785071343361160516137400145900245772101100046940001410000563662202705124966121780120758117549922569123890555BlogScoringEnvironmentFAQAbout UsSupportCareersTerms Of ServicePrivacy Policy

Given the CITY and COUNTRY tables, query the names of all the continents (COUNTRY.Continent) and their respective average city populations (CITY.Population) rounded down to the nearest integer.

Query a count of the number of cities in CITY having a Population larger than .Input FormatThe CITY table is described as follows:

Write a query to find the difference between the maximum and minimum population values recorded in the 'CITY' table.

Given the CITY and COUNTRY tables, query the sum of the populations of all cities where the CONTINENT is 'Asia'.