Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for America is USA. The CITY table is described as follows:
- all columns for all American cities
- in the CITY table
select * from city a where a.countrycode="USA" and a.population > 100000
