Weather Observation Station 5

  • + 1 comment

    @andy_slowmo Looks like you are right. So it seems if we wanted to be very detailed we could do:

    SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY 2 ASC, 1 ASC LIMIT 1;
    SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY 2 DESC, 1 ASC LIMIT 1
    

    That way the code looks more representative of the results