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!
Nowy kurs! Każdy programista powinien nauczyć się Generative AI!
Wypróbuj darmową lekcję
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 Odpowiedź
+ 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