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 will be returned (from the start position)

RIGHT()

The RIGHT() function extracts a number of characters from a string (starting from right).

Syntax

RIGHT(string, number_of_chars)

Parameter Values

Parameter	Description
string	Required. The string to extract from
number_of_chars	Required. The number of characters to extract. If number_of_chars > string, it returns string

Solution : 

#Way 1 : 

select distinct(city) from STATION where lower(RIGHT(city,1)) IN ('a','e','i','o','u');



#Way 2 : 

select distinct(city) from STATION where lower(RIGHT(city,1)) IN ('a','e','i','o','u')