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:

Query all columns for all American cities in the CITY table with populations larger than 100000. 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;

What is the US Census Bureau requirement for a place to be classified as urban?no less than 1 million peoplea population of 10,000 or moreat least 1,000 people per square mileany population over 100,000 people

According to the US Census Bureau, the 10 largest American cities (by popula‐tion) in 2010 were as follows:• New York, NY (8,175,133 people)• Los Angeles, CA (3,792,621)• Chicago, IL (2,695,598)• Houston, TX (2,100,263)• Philadelphia, PA (1,526,006)• Phoenix, AZ (1,445,632)• San Antonio, TX (1,327,407)• San Diego, CA (1,307,402)• Dallas, TX (1,197,816)• San Jose, CA (945,942)Define an array (or arrays) that holds this information about locations and popu‐lations. Print a table of locations and population information that includes thetotal population in all 10 cities.