Revising the Select Query II | Hackerrank | SQL | Basic Select | Solution

 

Problem : https://www.hackerrank.com/challenges/revising-the-select-query-2/problem

Solution : 

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