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

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

Solution : 

/*

Enter your query here.

*/

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

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;

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

 

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

Solution : 

SELECT NAME FROM CITY WHERE COUNTRYCODE = "JPN";

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;

Covariant Return Types | Advanced Java | HackerRank | Solution | Color The Code

Problem : https://www.hackerrank.com/challenges/java-covariance/problem

Solution :