Weather Observation Station 5

  • + 0 comments

    SELECT city, length_of_city FROM ( SELECT TOP 1 city, LEN(city) AS length_of_city FROM station ORDER BY LEN(city) ASC, city ASC ) AS MinCity

    UNION ALL

    SELECT city, length_of_city FROM ( SELECT TOP 1 city, LEN(city) AS length_of_city FROM station ORDER BY LEN(city) DESC, city ASC ) AS MaxCity;