Weather Observation Station 12

Sort by

recency

|

2406 Discussions

|

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE CITY REGEXP '^[^aeiou].*[^aeiou]$'

  • + 0 comments

    Query the list of CITY names from STATION that do not start with vowels and do not end with vowels. Your result cannot contain duplicates.

  • + 0 comments

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

  • + 0 comments

    SELECT DISTINCT city FROM station WHERE city REGEXP '^[^aeiouAEIOU]' AND city REGEXP '[^aeiouAEIOU]$';

  • + 0 comments

    select distinct city from station where city not like 'A%' and city not like 'E%' and city not like 'I%' and city not like 'O%' and city not like 'U%' and city not like '%a' and city not like '%e' and city not like '%i' and city not like '%o' and city not like '%u';