Skip to content

Instantly share code, notes, and snippets.

@Justus-coded

Justus-coded/Weather Observation Station 9.sql

Created September 30, 2020 13:37
Show Gist options
  • Save Justus-coded/6ebb6076d4925039d4cc54fa3b4a7490 to your computer and use it in GitHub Desktop.
Save Justus-coded/6ebb6076d4925039d4cc54fa3b4a7490 to your computer and use it in GitHub Desktop.
Download ZIP
Hackerrank SQL Challenge
Raw
Weather Observation Station 9.sql
/*
Query the list of CITY names from STATION that do not start with vowels. Your result cannot contain duplicates.
*/
SELECT DISTINCT CITY
FROM STATION
WHERE 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