10. Weather Observation Station 5.sql

--Problem: https://www.hackerrank.com/challenges/weather-observation-station-5/problem

--For Min
SELECT * 
FROM (SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY ASC)
WHERE ROWNUM=1;


--FOR MAX
SELECT * 
FROM (SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) ASC, CITY ASC)
WHERE ROWNUM=1;