You are viewing a single comment's thread. Return to all comments →
/* Finds smallest city name */
Select City, Length(City) From Station Order by Length(City), City ASC Limit 1;
/* Finds Longest city name*/
Select City, Length(City) From Station Order by Length(City) DESC, City ASC Limit 1;
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
/* Finds smallest city name */
Select City, Length(City) From Station Order by Length(City), City ASC Limit 1;
/* Finds Longest city name*/
Select City, Length(City) From Station Order by Length(City) DESC, City ASC Limit 1;