Weather Observation Station 6 | Basic Select | SQL | HackerRank Solution

 

Problem : https://www.hackerrank.com/challenges/weather-observation-station-6/problem

Solution :

/*

Enter your query here.

*/

SELECT CITY FROM STATION WHERE LEFT(CITY,1) IN ('a','e','i','o','u');

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