Weather Observation Station 5
- URL : https://www.hackerrank.com/challenges/weather-observation-station-5/problem
- Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically.
- MySQL Solution
1
2
3
4
5
6
7
select city, length(city)
from station
order by length(city) asc, city asc limit 1;
select city, length(city)
from station
order by length(city) desc, city asc limit 1;