Coding Problem 3 - Weather Observation Station 7 [HackerRank - SQL]
Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION . Your result cannot contain duplicates. Input Format The STATION table is described as follows: where LAT_N is the northern latitude and LONG_W is the western longitude. Notes : SUBSTR() The SUBSTR() function extracts a substring from a string (starting at any position). Note: The SUBSTR() and MID() functions equals to the SUBSTRING() function. Syntax SUBSTR( string , start , length ) Parameter Values Parameter Description string Required. The string to extract from start Required. The start position. Can be both a positive or negative number. If it is a positive number, this function extracts from the beginning of the string. If it is a negative number, this function extracts from the end of the string length Optional. The number of characters to extract. If omitted, the whole string w...