반응형
HeackerRank Weather Observation Station 5
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;반응형
'코딩 테스트 > SQL' 카테고리의 다른 글
| HeackerRank Weather Observation Station 9 (1) | 2023.10.25 |
|---|---|
| HeackerRank Weather Observation Station 8 (1) | 2023.10.24 |
| HeackerRank Basic Select Weather Observation Station 7 (0) | 2023.10.17 |
| HeackerRank Basic Select Weather Observation Station 6 (0) | 2023.10.16 |
| HeackerRank Weather Observation Station 4 (0) | 2023.10.14 |