Weather Observation Station 5

  • + 1 comment

    MYSQL

    SELECT CITY, CHARACTER_LENGTH(CITY) AS LengthOfName FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1; SELECT CITY, CHARACTER_LENGTH(CITY) AS LengthOfName FROM STATION ORDER BY LENGTH(CITY) DESC, CITY DESC LIMIT 1