https://www.hackerrank.com/challenges/weather-observation-station-5/problem?isFullScreen=true
Weather Observation Station 5 | HackerRank
Write a query to print the shortest and longest length city name along with the length of the city names.
www.hackerrank.com
SELECT CITY, LENGTH(CITY)
FROM STATION
ORDER BY 2,1
LIMIT 1;
SELECT CITY, LENGTH(CITY)
FROM STATION
ORDER BY 2 DESC,1 ASC
LIMIT 1
'Growth 🌳 > Practice 💻' 카테고리의 다른 글
| [Hacker Rank] Weather Observation Station 16 (0) | 2022.08.22 |
|---|---|
| [Hacker Rank] Weather Observation Station 14 (0) | 2022.08.22 |
| [Hacker Rank] The Blunder (0) | 2022.08.20 |
| [SQL] 연습문제 (0) | 2022.08.03 |
| [Hacker Rank] Weather Observation Station 20 : MySQL (0) | 2022.08.02 |