Japanese Cities' Attributes | Basic Select | SQL | Hackerrank | Solution

Problem : https://www.hackerrank.com/challenges/japanese-cities-attributes/problem

Solution : 

SELECT * FROM CITY WHERE COUNTRYCODE="JPN";

Select All | Hackerrank | Basic Select | SQL | Basic Select | Solution

 

Problem : https://www.hackerrank.com/challenges/select-all-sql/problem

Solution : 

SELECT * FROM CITY;

Revising the Select Query I | HackerRank | Basic Select | SQL | Complete Playlist

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

SOLUTION : 

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