Hello coders, today we are going to solve Weather Observation Station 6 HackerRank Solution in SQL.
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:
where LAT_N is the northern latitude and LONG_W is the western longitude.
Solution – Weather Observation Station 6 in SQL
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%";
Disclaimer: The above Problem (Weather Observation Station 6) is generated by Hacker Rank but the Solution is Provided by CodingBroz. This tutorial is only for Educational and Learning Purpose.