revising_the_select_query1.sql

-- Language: MySQL

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