Weather Observation Station 10 HackerRank

Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates.

Input Format

The STATION table is described as follows:

Works on MS SQL SERVER

SELECT DISTINCT city FROM station WHERE city NOT LIKE '%[aeiou]';

view raw WeatherOStation10-HR hosted with ❤ by GitHub

Congratulations, you passed the sample test case.

Click the Submit Code button to run you code against all the test cases.

Your Output (stdout)

Addison 
Agency 
Alanson 
Albany 
Albion 
Algonac 
Allerton 
Alton 
Andover