SELECT ID,
       NAME,
       POPULATION,
       DISTRICT,
       COUNTRYCODE
FROM CITY
WHERE COUNTRYCODE = 'USA'
AND POPULATION > 100000;