Query the NAME field for all American cities in the CITY table with populations larger than 120000. The CountryCode for America is USA.The CITY table is described as follows:

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.

Big CountriesThere is a table WorldnamecontinentareapopulationgdpAfghanistanAsia6522302550010020343000AlbaniaEurope28748283174112960000AlgeriaAfrica238174137100000188681000AndorraEurope468781153712000AngolaAfrica124670020609294100990000A country is big if it has an area of bigger than 3 million square km or apopulation of more than 25 million.Write a SQL solution to output big countries' name, population and area.For example, according to the above table, we should output:namepopulationareaAfghanistan25500100652230Algeria371000002381741Optionsselect name, population, areawhere area >= 3000000 or population >= 25000000;select name, populationfrom Worldwhere area >= 3000000 or population >= 25000000;select name, population, areafrom Worldwhere area >= 3000000 or population >= 25;select name, population, areafrom Worldwhere area >= 3000000 or population >= 25000000;

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

Query all columns (attributes) for every row in the CITY table.The CITY table is described as follows:

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