Weather Observation Station 5

  • + 5 comments

    Here is the answer in oracle without union and in single sql statement.

    select MIN(city) , length(city) from station group by length(city) having length(city) =(select MIN(length(city)) from station ) or length(city) =(select MAX(length(city)) from station ) order by length(city) ASC;