Weather Observation Station 5

  • + 0 comments
    WITH CITY_LENGTH_1 AS (
        SELECT MIN(CITY) AS city,
        LEN(CITY) AS city_length
        FROM STATION
        GROUP BY LEN(CITY)
    )
    SELECT city,
        city_length
    FROM CITY_LENGTH_1
    WHERE city_length IN (SELECT MIN(city_length) FROM CITY_LENGTH_1)
        OR city_length IN (SELECT MAX(city_length) FROM CITY_LENGTH_1)
    ORDER BY city_length