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.
Query the list of CITY names starting with vowels (i.e.,
u) from STATION. Your result cannot contain duplicates.
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
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