Showing posts with label right in sql. Show all posts
Showing posts with label right in sql. Show all posts

Friday, March 5, 2021

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 10 | Basic Select | SQL | HackerRank | Solution



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

Solution :


/*

Enter your query here.

*/


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











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 7 | Basic Select | SQL | Practice | HackerRank | Solution

 


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

Solution : 

/*

Enter your query here.

*/


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