5. Solution of Hacker Rank Weather Observation Station 8.

Author: neptune | 18th-Aug-2024
🏷️ #SQL #Hackerrank

Solution of Weather Observation Station 8

Problem Statement : Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates.

where LAT_N is the northern latitude and LONG_W is the western longitude.


Solution :

For this challenge, we must:

  1. Use a Distinct() function to get unique cities.

  2. Restrict the selected rows using the WHERE clause so that only records where CITY names start with vowels and end with vowels are returned.




Query :

SELECT Distinct CITY 

FROM STATION 

WHERE lower(substr(CITY, 1, 1)) in ('a', 'e', 'i', 'o', 'u') and lower(substr(CITY, length(CITY), 1)) in ('a', 'e', 'i', 'o', 'u');


Watch below video for regular expression solution:




Output:


Hope you learn something !!!

If you have any questions let me know in the comment section.




👉 Read More
The Blunder | Hackerrank
7.Solution of Hacker Rank The Report
Identifying the Odd One Out in a Series of Strings | Hackerrank
4. Solution of Hacker Rank Weather Observation Station 6.
3. Solution of Hacker Rank Weather Observation Station 4.
The PADS | Hackerrank
6. Solution of Hacker Rank Employee Salaries.
1. Basic SQL Select Query of Hacker Rank.
Generate Fibonacci Sequence - JavaScript | Hackerank
Team Formation Hackerrank | Julia
Modified 0-1 knapsack problem | Frsco Play Hackerrank
2. Solution of Hacker Rank Weather Observation Station 3.
Weather Observation Station 18 | Hackerrank
Solving the Ice Cream Parlor Problem | Hackerrank
AngularJS - Know Tech Frameworks | Fresco Play
PySpark Milestone Black Friday Sales Data | Fresco Play Hackerrank
30+ SQL Interview Questions
Backspace String Compare using R | Fresco Play
Top Earners | HackerRank
Python - Number Based Problem | Hackerrank
Explore more Blogs...