Weather Observation Station 5

  • + 0 comments

    according to these question we are write query but return a wrong answer SELECT CITY , LENGTH(CITY) AS NAME_LENGTH FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC LIMIT 1 ) UNION ( SELECT CITY , LENGTH(CITY) AS NAME_LENGTH FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC LIMIT 1 );