Weather Observation Station 17.sql

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

SELECT ROUND(MIN(LONG_W), 4)
FROM STATION
WHERE LAT_N IN (
    SELECT MIN(LAT_N) 
    FROM STATION
    WHERE LAT_N > 38.7780
);