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.
풀이
제출한 답
select round(LONG_W, 4)
from station
where LAT_N in (select min(LAT_N) from station where LAT_N > 38.7780)
'데이터 분석 > SQL 연습문제' 카테고리의 다른 글
| New Companies (HackerRank) (0) | 2022.10.05 |
|---|---|
| Contest Leaderboard (HackerRank) (0) | 2022.10.04 |
| 185. Department Top Three Salaries (LeetCode) (0) | 2022.09.26 |
| The Report (HackerRank) (0) | 2022.09.20 |
| Challenges (HackerRank) (0) | 2022.09.19 |
댓글