SELECT CITY, name_length
FROM (
    SELECT 
        CITY,
        LENGTH(CITY) as name_length,
        ROW_NUMBER() OVER (ORDER BY LENGTH(CITY) ASC, CITY ASC) as shortest_rank,
        ROW_NUMBER() OVER (ORDER BY LENGTH(CITY) DESC, CITY ASC) as longest_rank
    FROM STATION
) ranked
WHERE shortest_rank = 1 OR longest_rank = 1;