[HackerRank] Weather Observation Station 13

mzzzi·2022년 4월 21일
0

HackerRank SQL

목록 보기
35/52
post-thumbnail

MySQL > Weather Observation Station 13


Weather Observation Station 13
Query the sum of Northern Latitudes (LAT_N) from STATION having values greater than and less than 78.7880. Truncate 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 TRUNCATE(SUM(LAT_N), 4)
FROM STATION
WHERE 38.7880 < LAT_N AND LAT_N < 137.2345 ;
profile
무럭무럭 성장하라🌳

0개의 댓글