Weather Observation Station 16 | HackerRank
Query the smallest of STATION's Northern Latitudes that is greater than 38.7780, and round to 4 decimal places
www.hackerrank.com
Query the smallest Northern Latitude (LAT_N) from STATION that 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/b3vcy9/btrkOjGb3Af/jswJu4btv4S9OO1FiBd370/img.jpg)
where LAT_N is the northern latitude and LONG_W is the western longitude.
[My Answer]
SELECT ROUND(MIN(LAT_N), 4)
FROM STATION
WHERE LAT_N >38.7780
똑같은걸 계속 푸는 느낌은 기분 탓이겠지?..
'Code Problems > SQL_ HackerRank' 카테고리의 다른 글
[HackerRank] Weather Observation Station 18 (0) | 2021.11.26 |
---|---|
[HackerRank] Weather Observation Station 17 (0) | 2021.11.14 |
[HackerRank] Weather Observation Station 15 (0) | 2021.11.11 |
[HackerRank] Weather Observation Station 14 (0) | 2021.11.11 |
[HackerRank] Weather Observation Station 13 (0) | 2021.11.11 |