Skip to content

Instantly share code, notes, and snippets.

@Justus-coded

Justus-coded/Weather Observation Station 12.sql

Created September 30, 2020 13:48
Show Gist options
  • Save Justus-coded/f6dd453ce930cf8ce5a2137c45318767 to your computer and use it in GitHub Desktop.
Save Justus-coded/f6dd453ce930cf8ce5a2137c45318767 to your computer and use it in GitHub Desktop.
Download ZIP
Hackerrank SQL Challenge
Raw
Weather Observation Station 12.sql
/*
Query the list of CITY names from STATION that do not start with vowels and 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')) AND (LEFT(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