Select By ID | Basic Select | Hackerrank | Solution | SQL

 

Problem : https://www.hackerrank.com/challenges/select-by-id/problem

Solution : 

SELECT * FROM CITY WHERE ID = 1661;

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";

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";