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

 

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

Solution : 

/*

Enter your query here.

*/

SELECT DISTINCT(CITY) FROM STATION WHERE ID%2=0; 

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

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

Solution : 

/*

Enter your query here.

*/

SELECT CITY , STATE FROM STATION;