Smash the code

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: Solution: SELECT * FROM CITY WHERE POPULATION >100000 AND COUNTRYCODE='USA';

The  CITY  table is described as follows: Solution: SELECT NAME FROM CITY WHERE POPULATION >120000 AND COUNTRYCODE='USA';