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.
select * from (select city,length(city) from station
where length(city)=(select min(length(city)) from station) order by 1 asc limit 1)
as T
union
select * from (select city,length(city) from station
where length(city)=(select max(length(city)) from station)
order by 1 asc limit 1) as T1
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 →
select * from (select city,length(city) from station where length(city)=(select min(length(city)) from station) order by 1 asc limit 1) as T union select * from (select city,length(city) from station where length(city)=(select max(length(city)) from station) order by 1 asc limit 1) as T1