31 January 2018

Weather Observation Station 5

My solution:
(SELECT CITY, 
        LENGTH(CITY) 
 FROM   STATION 
 GROUP  BY CITY 
 HAVING LENGTH(CITY) <= (SELECT MIN(LENGTH(CITY)) 
                         FROM   STATION) 
 LIMIT  1) 
UNION 
(SELECT CITY, 
        LENGTH(CITY) 
 FROM   STATION 
 GROUP  BY CITY 
 HAVING LENGTH(CITY) >= (SELECT MAX(LENGTH(CITY)) 
                         FROM   STATION) 
 LIMIT  1); 

Weather Observation Station 11

My solution:
SELECT DISTINCT CITY 
FROM   STATION 
WHERE  CITY REGEXP "^.*[^aeiou]$" 
        OR CITY REGEXP "^[^AEIOU].*$"; 

Weather Observation Station 10

My solution:
SELECT DISTINCT CITY 
FROM   STATION 
WHERE  CITY REGEXP "^.*[^aeiou]$"; 

Weather Observation Station 9

My solution:
SELECT DISTINCT CITY 
FROM   STATION 
WHERE  CITY REGEXP "^[^AEIOU].*$"; 

Weather Observation Station 8

My solution:
SELECT DISTINCT CITY 
FROM   STATION 
WHERE  CITY REGEXP "^(A|E|I|O|U).*(a|e|i|o|u)$"; 

Weather Observation Station 7

My solution:
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"; 

Weather Observation Station 6

My solution:
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%";