4. Solution of Hacker Rank Weather Observation Station 6.

Author: neptune | 23rd-Jan-2023
🏷️ #SQL #Hackerrank

Weather Observation Station 6

Problem Statement : Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. 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 are returned.


Query :

SELECT Distinct CITY 

FROM STATION 

WHERE city like 'a%' or city like 'e%' or city like 'i%' or city like 'o%' or city like 'u%';



Output:


Hope you learn something !!!

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




👉 Read More
The Blunder | Hackerrank
5. Solution of Hacker Rank Weather Observation Station 8.
7.Solution of Hacker Rank The Report
Identifying the Odd One Out in a Series of Strings | Hackerrank
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...