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%"; 

Weather Observation Station 4

My solution:

SELECT COUNT(CITY) - COUNT(DISTINCT CITY) 
FROM   STATION; 

Weather Observation Station 3

My solution:

SELECT DISTINCT CITY 
FROM   STATION 
WHERE  ID % 2 = 0; 

Weather Observation Station 1

My solution:

SELECT CITY, 
       STATE 
FROM   STATION; 

Japanese Cities' Names

My solution:

SELECT NAME 
FROM   CITY 
WHERE  COUNTRYCODE = "JPN"; 

Japanese Cities' Attributes

My solution:

SELECT * 
FROM   CITY 
WHERE  COUNTRYCODE = "JPN";