Weather Observation Station 5

  • + 7 comments

    Yes. You also could avoid HAVING keyword and use UNION

    (
        SELECT CITY, LENGTH(CITY) AS `length`
        FROM STATION
        WHERE 1
        ORDER BY `length` ASC, CITY ASC
        LIMIT 1
    ) UNION (
        SELECT CITY, LENGTH(CITY) AS `length`
        FROM STATION
        WHERE 1
        ORDER BY `length` DESC, CITY ASC
        LIMIT 1
    )