Query shortest and longest data by using LENGTH(), ORDER BY, LIMIT

Query shortest and longest cities and length from the STATION table by using LENGTH(), ORDER BY, LIMIT. This is the solution of HackerRank's Weather Observation Station 5 SQL problem.

Table name: STATION

Table Structure:

SQL Query:

(SELECT CITY, LENGTH(CITY) AS len 
FROM STATION
ORDER BY len ASC, CITY ASC
LIMIT 1)
UNION
(SELECT CITY, LENGTH(CITY) AS len 
FROM STATION
ORDER BY len DESC, CITY DESC
LIMIT 1);