SESSION NAME: Advance Select - 1

QUESTION NAME: Query Population - 12000 in USA


TABLE DESCRIPTION:
Query the table of all American cities in CITY with 
populations larger than 120000. The CountryCode for America is USA.

CODE:
select * from CITY where COUNTRYCODE='USA' AND POPULATION>120000;