[SQL][HackerRank] Weather Observation Station 5

https://www.hackerrank.com/challenges/weather-observation-station-5/problem?h_r=next-challenge&h_v=zen&h_r=next-challenge&h_v=zen

Weather Observation Station 5 | HackerRank

select CITY, LENGTH(CITY)
from STATION
ORDER BY LENGTH(CITY), CITY
LIMIT 1;

select CITY, LENGTH(CITY)
from STATION
ORDER BY LENGTH(CITY) DESC, CITY
LIMIT 1;

choose the one that comes first이므로 내림차순으로 정렬한뒤에 LIMIT를 사용해서 1개만 불러온다.