[hackerrank] Prepare > SQL > Aggregation > Weather Observation Station 13
[문제]
Query the sum of Northern Latitudes (LAT_N) from STATION having values greater than and less than . Truncate your answer to 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.
[MYSQL]
[ORCALE]
select round(sum(lat_n),4)
from station
where lat_n >= 38.7880 and lat_n <= 137.2345;
반응형
'HackerRank > SQL' 카테고리의 다른 글
[hackerrank] Weather Observation Station 15 (0) | 2022.08.31 |
---|---|
[hackerrank] Weather Observation Station 14 (0) | 2022.08.31 |
[hackerrank] Weather Observation Station 2 (0) | 2022.08.31 |
[hackerrank] Top Earners (0) | 2022.08.31 |
[hackerrank] The Blunder (0) | 2022.08.25 |