SQL

Hacker rank Weather Observation Station 5

무적김두칠 2021. 10. 20. 21:44

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
반응형