728x90
반응형
https://www.hackerrank.com/challenges/weather-observation-station-17/problem?isFullScreen=true
Weather Observation Station 17 | HackerRank
Query the Western Longitude for the smallest value of the Northern Latitudes greater than 38.7780 in STATION and round to 4 decimal places.
www.hackerrank.com
문제
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.
Input Format
The STATION table is described as follows:
![](https://blog.kakaocdn.net/dn/qsYbQ/btssfHM4HMq/ZSt7Yd8aVSPY3a9K0C92g1/img.jpg)
where LAT_N is the northern latitude and LONG_W is the western longitude.
Code
SELECT ROUND(LONG_W, 4)
FROM STATION
WHERE LAT_N > 38.7780
ORDER BY LAT_N
LIMIT 1
728x90
반응형
'SQL > MySQL' 카테고리의 다른 글
[MySQL/HackerRank] Weather Observation Station 19 (0) | 2023.08.25 |
---|---|
[MySQL/HackerRank] Weather Observation Station 18 (0) | 2023.08.25 |
[MySQL/HackerRank] Weather Observation Station 16 (0) | 2023.08.25 |
[MySQL/HackerRank] Weather Observation Station 15 (0) | 2023.08.25 |
[MySQL/HackerRank] Weather Observation Station 14 (0) | 2023.08.25 |