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

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

Solution :

/*

Enter your query here.

*/

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

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

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

Solution : 

/*

Enter your query here.

*/

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

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

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

Solution :

/*

Enter your query here.

*/

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

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');