[SQL]weather-observation-station-5

https://www.hackerrank.com/challenges/weather-observation-station-5

Weather Observation Station 5 | HackerRank

with base as (
select
    city, length(city) len
    , dense_rank() over (order by length(city), city) rn1
    , dense_rank() over (order by length(city) desc, city) rn2  
from station
)
select
    distinct city, len
from base
where rn1 = 1 or rn2 = 1