www.hackerrank.com/challenges/weather-observation-station-15/problem
Weather Observation Station 15 | HackerRank
Query the Western Longitude for the largest Northern Latitude under 137.2345, rounded to 4 decimal places.
www.hackerrank.com
Answer
select round(long_w,4)
from station
where LAT_N < 137.2345
order by lat_n desc
limit 1www.hackerrank.com/challenges/weather-observation-station-16/problem
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
Answer
select min(round(lat_n,4))
from station
where lat_n > 38.7780
728x90
반응형
'SQL & DB > HackerRank SQL Problem' 카테고리의 다른 글
| [HackerRank SQL] Weather Observation Station 19, 20(MySQL) (0) | 2021.03.01 |
|---|---|
| [HackerRank SQL] Weather Observation Station 17, 18(MySQL) (0) | 2021.03.01 |
| [HackerRank SQL] Weather Observation Station 13, 14(MySQL) (0) | 2021.03.01 |
| [HackerRank SQL] Top Earners (0) | 2021.02.27 |
| [HackerRank SQL] The Blunder (0) | 2021.02.27 |