QUESTION NO:1111118.

QUESTION NAME: Query Select 10000 and USA.

TABLE DESCRIPTION:
Query all columns for all American cities in CITY with populations larger than 100000. The CountryCode for America is USA.

CODE:
select * from city where countrycode ='usa' and population >100000 ;