Weather Observation Station 5

  • + 0 comments
    WITH cte AS (
            (SELECT city, LENGTH(city)
            FROM STATION
            ORDER BY LENGTH(city) ASC, city ASC LIMIT 1)
        UNION ALL
            (SELECT city, LENGTH(city)
            FROM STATION
            ORDER BY LENGTH(city) DESC LIMIT 1)
    )
    
    SELECT * FROM cte