You are viewing a single comment's thread. Return to all comments →
I resolved it like this
select city, length(city) from station where length(city) in (select max(length(city)) from station) order by city limit 1;
select city, length(city) from station where length(city) in (select min(length(city)) from station) order by city limit 1;
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 →
I resolved it like this
select city, length(city) from station where length(city) in (select max(length(city)) from station) order by city limit 1;
select city, length(city) from station where length(city) in (select min(length(city)) from station) order by city limit 1;