Query the list of CITY names have vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates. | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
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 Answer
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