SELECT * FROM CITY WHERE POPULATION>100000 AND COUNTRYCODE = 'USA'