https://www.hackerrank.com/challenges/weather-observation-station-5/problem?isFullScreen=false
- STATION에서 CITY의 이름이 가장 짧은 것과 긴 것을 1개씩 출력
- 같은 길이는 알파벳으로 정렬하여 첫번째를 출력함
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 DESC LIMIT 1 ;
SELECT col1, col2
LENGTH(col)
-> 띄어쓰기 포함값. CHAR_LENGTH(col)
사용 (띄어쓰기 포함x, 한글도 1글자로 취급)-- CHAR_LENGTH(col)을 사용한 정렬도 맞게 나옴
SELECT CITY, CHAR_LENGTH(CITY) FROM STATION ORDER BY CHAR_LENGTH(CITY) ASC, CITY ASC LIMIT 1 ;
SELECT CITY, CHAR_LENGTH(CITY) FROM STATION ORDER BY CHAR_LENGTH(CITY) DESC, CITY DESC LIMIT 1