본문 바로가기
SQL

Hacker rank Weather Observation Station 5

by 무적김두칠 2021. 10. 20.

1
2
3
4
5
6
7
8
9
10
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
;
cs
반응형

댓글