Cancel

Weather Observation Station 17

Posted May 31, 2020 2020-05-31T20:00:00+09:00 by HyunMin Kim

URL : https://www.hackerrank.com/challenges/weather-observation-station-17/problem
Query the Western Longitude (LONG_W)where the smallest Northern Latitude (LAT_N) in STATION is greater than 38.7780. Round your answer to 4 decimal places.
MySQL Solution

select round(long_w,4)
from station
where lat_n = (select min(lat_n)
              from station
              where lat_n > 38.7780)

This post is licensed under CC BY 4.0 by the author.