Revising-the-select-Query-1.sql

select * from CITY where COUNTRYCODE='USA' AND POPULATION>100000;