014. Weather Observation Station 17.sql

-- # Problem: https://www.hackerrank.com/challenges/weather-observation-station-17/problem
-- # Score: 15


SELECT *
FROM (
    SELECT ROUND(Long_W, 4)
    FROM Station
    WHERE Lat_N > 38.7780
    ORDER BY Lat_N ASC)
WHERE ROWNUM = 1;