Hackerrank - Revising the Select Query II solution

Problem link

Solution one:

SELECT NAME FROM CITY WHERE COUNTRYCODE = "USA" AND POPULATION > 120000;