[HackerRank] Weather Observation Station 5

select city, char_length(city)
from station
order by char_length(city) desc, city 
limit 1; 

select city, char_length(city)
from station
order by char_length(city), city 
limit 1;

문제를 잘 읽자.

마지막에 이 문제의 정답의 특징을 적어 놓았다.

"You can write two separate queries to get the desired output. It need not be a single query."

 

(문제 출처 - https://www.hackerrank.com/domains/sql)