Query the list of CITY names starting with 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 starting with vowels (a, e, i, o, u) from STATION. Your result cannot contain duplicates.

19th Dec 2016, 9:54 AM
Akwin Lopez
Akwin Lopez - avatar
1 Answer
+ 2
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:54 AM
Akwin Lopez
Akwin Lopez - avatar