Weather Observation Station 5

  • + 0 comments

    Simple Answer is the Greatest

    SELECT TOP 1 CITY, LEN(CITY) FROM STATION ORDER BY LEN(CITY)ASC, CITY ASC;

    SELECT TOP 1 CITY, LEN(CITY) FROM STATION ORDER BY LEN(CITY) DESC, CITY ASC;