https://www.hackerrank.com/challenges/weather-observation-station-5/problem
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
Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically.
The STATION table is described as follows:
CITY 이름중에 가장 짧은 것과 가장 긴 것을 각각 찾고, 길이가 같은 것이 있을 경우 알파벳 순으로 가장 빠른 것을 찾는 문제
반응형
'지식저장소 > SQL' 카테고리의 다른 글
| [SQL/MYSQL] HackerRank - Weather Observation Station 9 (0) | 2022.06.10 |
|---|---|
| [SQL/MYSQL] HackerRank - Weather Observation Station 8 (0) | 2022.06.10 |
| [SQL/MYSQL] HackerRank - Weather Observation Station 7 (0) | 2022.06.10 |
| [SQL/MYSQL] HackerRank - Weather Observation Station 6 (0) | 2022.06.10 |
| [SQL/MYSQL] HackerRank - Weather Observation Station 4 (0) | 2022.06.10 |