[HackerRank] Weather Observation Station 5

https://www.hackerrank.com/challenges/weather-observation-station-5/problem

Weather Observation Station 5 | HackerRank

 

Code 1 

(SELECT City, Length(City)
FROM STATION
ORDER BY LENGTH(City), City ASC
LIMIT 1)

UNION

(SELECT City, Length(City)
FROM STATION
ORDER BY LENGTH(City) DESC, City ASC
LIMIT 1);

 

Code 2

#작은 따옴표로 이어주면 괄호 굳이 안해도 된다고 한다 

SELECT City, Length(City)
FROM STATION
ORDER BY LENGTH(City), City ASC
LIMIT 1 ;

UNION

SELECT City, Length(City)
FROM STATION
ORDER BY LENGTH(City) DESC, City ASC
LIMIT 1

참고:

https://mansi.tistory.com/entry/SQL-%EB%AC%B8%EC%A0%9C%ED%92%80%EC%9D%B4%EB%8A%94-%EC%9E%AC%EB%B0%8C%EC%96%B4-%ED%95%B4%EC%BB%A4%EB%9E%AD%ED%81%AC-Weather-Observation-Station-5