SQL Solution For HackerRank Problem: Weather Observation Station 6
This another problem from HackerRank called Weather Observation Station 6, Here is the SQL solution in MySQL environment.
Problem Description
Query the list of CITY names starting with vowels (i.e., a
, e
, i
, o
, or u
) from STATION. Your result cannot contain duplicates.
Input Format
The STATION table is described as follows:
Field | Type -------------------------- ID | NUMBER CITY | VARCHAR2(21) STATE | VARCHAR2(2) LAT_N | NUMBER LONG_W | NUMBER
To know the details about the problem visit : Weather Observation Station 6
Solution
Please check the snippet for the sql implementation. If you have different approach in mind feel free to share in the comment below.
Originally posted at: github.com by @Thomas-George-T
Comments
Leave a comment
You are not LoggedIn but you can comment as an anonymous user which requires manual approval. For better experience please Login.