Weather Observation Station 17 / HackerRank, SQL, MySQL

문제

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

 

 

제출답안(MySQL)

SELECT ROUND(long_w, 4)
FROM station
WHERE lat_n = (SELECT MIN(lat_n) FROM station WHERE lat_n > 38.7780 )

 

 

문제 바로가기(MySQL)