We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
SELECT CITY, LENGTH(CITY) AS OUTPUT
FROM STATION
ORDER BY LENGTH(CITY) DESC, CITY ASC
LIMIT 1;
SELECT CITY, LENGTH(CITY) AS OUTPUT2
FROM STATION
ORDER BY LENGTH(CITY), CITY ASC
LIMIT 1;
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
SELECT CITY, LENGTH(CITY) AS OUTPUT FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC LIMIT 1; SELECT CITY, LENGTH(CITY) AS OUTPUT2 FROM STATION ORDER BY LENGTH(CITY), CITY ASC LIMIT 1;