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!
Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок
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 ответ
+ 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