Query 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:
xxxxxxxxxx
2
1
SELECT NAME FROM CITY
2
WHERE POPULATION> 120000 AND COUNTRYCODE = "USA"