We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
with cte as (
select city,length(city) as l,row_number() over ( order by length(city) desc,city) as r_desc,
row_number() over ( order by length(city) ,city) as r_asc
from station
)
select city,l from cte
where r_desc=1
union all
select city,l from cte
where r_asc=1;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 5
You are viewing a single comment's thread. Return to all comments →
with cte as ( select city,length(city) as l,row_number() over ( order by length(city) desc,city) as r_desc, row_number() over ( order by length(city) ,city) as r_asc from station ) select city,l from cte where r_desc=1 union all select city,l from cte where r_asc=1;