Query the NAME field for all American cities in the CITY table with populations larger than 120_0. The ountryCode for America is USA.
The CITY table is described as follows:
Answer :
SQL
select NAME as cities from CITY where POPULATION > 120000 and COUNTRYCODE='USA' ;