HackerRank MySQL - Weather Observation Station 5

Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically.

SELECT *
FROM
  (SELECT CITY, LENGTH(CITY)
   FROM STATION
   ORDER BY LENGTH(CITY), CITY)
WHERE ROWNUM = 1
UNION
SELECT *
FROM
  (SELECT CITY, LENGTH(CITY)
   FROM STATION
   ORDER BY LENGTH(CITY) DESC, CITY)
WHERE ROWNUM = 1;