Skip to content

Instantly share code, notes, and snippets.

@Justus-coded

Justus-coded/WOS_7.sql

Created September 29, 2020 17:19
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save Justus-coded/4f03eb2740efe1b45f4437960d9af97c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save Justus-coded/4f03eb2740efe1b45f4437960d9af97c to your computer and use it in GitHub Desktop.
Download ZIP
Hackerrank Challenge - Weather Observation Station(WOS)
Raw
WOS_7.sql
/*
Query the list of CITY names ending with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.
*/
SELECT DISTINCT CITY
FROM STATION
WHERE RIGHT(UPPER(CITY),1) IN ('A', 'E', 'I', 'O', 'U')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment