Talk is cheap. Show me the code.
SOLUTION :
SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = "USA";