Files
HackerRank-Solutions/SQL/Aggregation/Weather Observation Station 17.sql

10 lines
196 B
SQL

-- Author: Rodney Shaghoulian
-- Github: github.com/RodneyShag
-- HackerRank: hackerrank.com/RodneyShag
SELECT ROUND(LONG_W, 4)
FROM STATION
WHERE LAT_N > 38.7780
ORDER BY LAT_N
LIMIT 1;