Query the names of all American cities in CITY with populations larger than
120000
. TheCountryCode for America is USA
.
Input Format
The CITY table is described as follows:![CITY.jpg](https://s3.amazonaws.com/hr-challenge-images/8137/1449729804-f21d187d0f-CITY.jpg)
![CITY.jpg](https://s3.amazonaws.com/hr-challenge-images/8137/1449729804-f21d187d0f-CITY.jpg)
Query :
Select NAME from CITY CountryCode = 'USA' and Population > 120000;