Weather Observation Station 8

Sort by

recency

|

4705 Discussions

|

  • + 0 comments

    -- query the list of city names from station which have vowels a,i,o, and u as both first and last

    SELECT DISTINCT(CITY)

    FROM STATION

    WHERE LOWER(LEFT(CITY, 1)) IN ('a','i','u','e','o')
            AND LOWER(RIGHT(CITY, 1)) IN ('a','i','u','e','o'); 
    
  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE LOWER(LEFT (CITY,1))IN ('a','e','i','o','u') and lower(right(city,1))IN('a','e','i','o','u');

  • + 0 comments

    select distinct city from station where left(city,1) IN ('a','e','i','o','u')AND right(city,1)IN ('a','e','i','o','u') ;

  • + 0 comments

    SELECT DISTINCT CITY FROM STATION WHERE LOWER(LEFT(CITY,1)) IN ('a','e','i','o','u') AND LOWER(RIGHT(CITY,1)) IN ('a','e','i','o','u');

    This worked for me , first i kept getting it wrong and added lower.

  • + 0 comments

    select distinct city from station where city regexp '^[aeiouAEIOU].*[aeiouAEIOU]$';