0

Query the list of CITY names have vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.

19th Dec 2016, 9:57 AM
Akwin Lopez
Akwin Lopez - avatar
1 Antwort
0
SELECT DISTINCT city FROM station WHERE city LIKE '%A%' or city LIKE '%E%' or city LIKE '%I%' or city LIKE '%O%' or city LIKE '%U%';
19th Dec 2016, 9:58 AM
Akwin Lopez
Akwin Lopez - avatar