You are viewing a single comment's thread. Return to all comments →
select top 1 city, len(city) as length from station where len(city)=(select min(len(city)) from station) order by city;
select top 1 city, len(city) as length from station where len(city)=(select max(len(city)) from station) order by city;
--
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 top 1 city, len(city) as length from station where len(city)=(select min(len(city)) from station) order by city;
select top 1 city, len(city) as length from station where len(city)=(select max(len(city)) from station) order by city;
--