Solution :
SELECT * FROM CITY;
Solution :
SELECT * FROM CITY;
Solution :
SELECT NAME FROM CITY WHERE COUNTRYCODE = "JPN";
Solution :
SELECT * FROM CITY WHERE ID = 1661;
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";