Hackerrank - Revising the Select Query I solution

Problem link

Solution one:

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