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:

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 |