Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates. Input Format The STATION table is described as follows: Field Type ID NUMBER CITY VARC

Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates. Input Format The STATION table is described as follows: Field Type ID NUMBER CITY VARC

Comment

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%') AND (CITY LIKE '%a' OR CITY LIKE '%e' OR CITY LIKE '%i' OR CITY LIKE '%o' OR CITY LIKE '%u') order by city;

Popularity 2/10 Helpfulness 3/10 Language whatever

Source: github.com

Tags: city contain field format input list names whatever

Share

Link to this answer
Share Copy Link

Contributed on Jan 03 2023

Rahul gupta

0 Answers  Avg Quality 2/10

---

Closely Related Answers

Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates.

Comment

4

SELECT DISTINCT(CITY) FROM STATION WHERE (LOWER(CITY) LIKE 'a%' OR LOWER(CITY) LIKE 'e%' OR LOWER(CITY) LIKE 'i%' OR LOWER(CITY) LIKE 'o%' OR LOWER(CITY) LIKE 'u%') AND (CITY LIKE '%a' OR CITY LIKE '%e' OR CITY LIKE '%i' OR CITY LIKE '%o' OR CITY LIKE '%u')

Popularity 9/10 Helpfulness 8/10 Language whatever

Source: Grepper

Tags: city

Share

Link to this answer
Share Copy Link

Contributed on Jun 27 2022

SY Ng

0 Answers  Avg Quality 2/10

---

Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last characters. Your result cannot contain duplicates.

Comment

1

SELECT DISTINCT CITY FROM STATION WHERE REGEXP_LIKE(CITY, '^[aeiouAEIOU]') AND REGEXP_LIKE(CITY, '[aeiouAEIOU]$');

Popularity 9/10 Helpfulness 6/10 Language whatever

Source: hoojiv.tistory.com

Tags: city contain cont

Share

Link to this answer
Share Copy Link

Contributed on Apr 27 2022

Zayn Sheikh

0 Answers  Avg Quality 2/10

---