Hackerrank | MySQL | Weather Observation Station 17

Weather Observation Station 17

Problem

Weather Observation Station 17 | HackerRank

Query the Western Longitude (LONG_W)where the smallest Northern Latitude (LAT_N) in STATION is greater than . Round your answer to  decimal places.

 

 

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

SELECT round(Long_w,4)
FROM (
    SELECT *
    FROM Station
    WHERE Lat_n > 38.7780
) as sub
ORDER BY Lat_n
Limit 1