Weather Observation Station 5

  • + 0 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;