www.hackerrank.com/challenges/weather-observation-station-13/problem
Weather Observation Station 13 | HackerRank
Query the sum of Northern Latitudes having values greater than 38.7880 and less than 137.2345, truncated to 4 decimal places.
www.hackerrank.com
Answer
select Truncate(sum(lat_n),4) #Truncate your answer to 4 decimal places.
from station
where LAT_N between 38.7890 and 137.2345;
www.hackerrank.com/challenges/weather-observation-station-14/problem
Weather Observation Station 14 | HackerRank
Query the greatest value of the Northern Latitudes from STATION that are under 137.2345 and truncated to 4 decimal places.
www.hackerrank.com
Answer
select truncate(max(lat_n),4)
from station
where lat_n < 137.2345
728x90
반응형
'SQL & DB > HackerRank SQL Problem' 카테고리의 다른 글
| [HackerRank SQL] Weather Observation Station 17, 18(MySQL) (0) | 2021.03.01 |
|---|---|
| [HackerRank SQL] Weather Observation Station 15, 16(MySQL) (0) | 2021.03.01 |
| [HackerRank SQL] Top Earners (0) | 2021.02.27 |
| [HackerRank SQL] The Blunder (0) | 2021.02.27 |
| [HackerRank SQL] New Companies (MySQL) (0) | 2021.02.27 |