[HackerRank SQL] Weather Observation Station 5

James Jung·2021년 7월 27일
0
post-thumbnail

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

Code link
https://github.com/JamesJung01/Hackerrank_sql/blob/main/01_Easy/Weather_Observation_Stations5.sql

Case 1

SELECT CITY, LENGTH(CITY)
FROM STATION
ORDER BY LENGTH(CITY), CITY
LIMIT 1;

Case 2

SELECT CITY, LENGTH(CITY)
FROM STATION
ORDER BY LENGTH(CITY) DESC, CITY
LIMIT 1;

0개의 댓글