Query all columns for all American cities in CITY with populations larger than
100000
. TheCountryCode for America is USA
.
Input Format
The CITY table is described as follows:
Query:
select * from CITY where population>100000 and COUNTRYCODE='USA';