Skip to content

Instantly share code, notes, and snippets.

@Justus-coded

Justus-coded/Weather Observation Station 10.sql

Created September 30, 2020 13:40
Show Gist options
  • Save Justus-coded/2f736e69c44c42e96828c9cf936309e7 to your computer and use it in GitHub Desktop.
Save Justus-coded/2f736e69c44c42e96828c9cf936309e7 to your computer and use it in GitHub Desktop.
Download ZIP
Hackerrank SQL Challenge
Raw
Weather Observation Station 10.sql
/*
Query the list of CITY names from STATION that do not end with vowels. Your result cannot contain duplicates.
*/
SELECT DISTINCT CITY
FROM STATION
WHERE RIGHT(UPPER(CITY), 1) NOT IN ('A', 'E', 'I', 'O', 'U')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment