Weather Observation Station 5

  • + 2 comments

    Without use of variables (MySQL):

    SELECT CITY,LENGTH(CITY) FROM STATION WHERE LENGTH(CITY) = (
        SELECT MIN(LENGTH(CITY)) FROM STATION
    ) ORDER BY CITY LIMIT 1;
    
    SELECT CITY,LENGTH(CITY) FROM STATION WHERE LENGTH(CITY) = (
        SELECT MAX(LENGTH(CITY)) FROM STATION
    ) ORDER BY CITY LIMIT 1;