*DRY* | More readable way of writing the query | Weather Observation Station 6

[NuranTerlan]

Change to this ->

SELECT DISTINCT city FROM station
WHERE LEFT(city, 1) IN ('A', 'E', 'I', 'O', 'U')

LEFT(string, char_count) function lets you get the character(s) of a string from the left by specifying a count