Problem : https://www.hackerrank.com/challenges/revising-the-select-query-2/problem
Solution :
SELECT NAME FROM CITY WHERE POPULATION > 120000 AND COUNTRYCODE = "USA";
Problem : https://www.hackerrank.com/challenges/revising-the-select-query-2/problem
Solution :
SELECT NAME FROM CITY WHERE POPULATION > 120000 AND COUNTRYCODE = "USA";
SOLUTION :
SELECT * FROM CITY WHERE POPULATION > 100000 AND COUNTRYCODE = "USA";