[HackerRank/Basic Select] Weather Observation Station 5

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

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

 

• 세미콜론(;) : 쿼리문을 연결해주는 역할
• ORDER BY A (ASC/DESC) , B (ASC/DESC) : 먼저 A 컬럼에 대해 정렬 후 B 컬럼에 대해 정렬함