Revising the Select Query I

1. Problem

Problem page

2. Solution

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