Employee Salaries

My solution:

SELECT name 
FROM   Employee 
WHERE  salary > 2000 
       AND months < 10 
ORDER  BY employee_id; 

Employee Names

My solution:

SELECT name 
FROM   Employee 
ORDER  BY name; 

Higher Than 75 Marks

My solution:

SELECT Name 
FROM   STUDENTS 
WHERE  Marks > 75 
ORDER  BY RIGHT(Name, 3), 
          ID; 

Weather Observation Station 12

My solution:

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

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]$";