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');
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');
No comments:
Post a Comment