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:

where LAT_N is the northern latitude and LONG_W is the western longitude.
[My Answer]
SELECT ROUND(LONG_W, 4)
FROM STATION
WHERE LAT_N > 38.7780
ORDER BY LAT_N
LIMIT 1
뭔가 돌고 돌고 돌고?..
'Code Problems > SQL_ HackerRank' 카테고리의 다른 글
[HackerRank] Weather Observation Station 19 (0) | 2021.11.26 |
---|---|
[HackerRank] Weather Observation Station 18 (0) | 2021.11.26 |
[HackerRank] Weather Observation Station 16 (0) | 2021.11.14 |
[HackerRank] Weather Observation Station 15 (0) | 2021.11.11 |
[HackerRank] Weather Observation Station 14 (0) | 2021.11.11 |