Query all columns for all American cities in the CITY table with populations larger than 100,000. The CountryCode for America is USA.
The CITY table is described as follows:
Field
Type
ID
INT(11)
NAME
CHAR(35)
COUNTRYCODE
CHAR(3)
DISTRICT
CHAR(20)
POPULATION