728x90
반응형
https://www.hackerrank.com/challenges/weather-observation-station-2/problem?isFullScreen=true
문제
Query the following two values from the STATION table:
- The sum of all values in LAT_N rounded to a scale of decimal places.
- The sum of all values in LONG_W rounded to a scale of 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.
Code
SELECT ROUND(SUM(LAT_N), 2), ROUND(SUM(LONG_W), 2)
FROM STATION
728x90
반응형
'SQL > MySQL' 카테고리의 다른 글
[MySQL/HackerRank] Weather Observation Station 14 (0) | 2023.08.25 |
---|---|
[MySQL/HackerRank] Weather Observation Station 13 (0) | 2023.08.25 |
[MySQL/HackerRank] Top Earners (0) | 2023.08.25 |
[MySQL/HackerRank] African Cities (0) | 2023.08.21 |
[MySQL/HackerRank] Population Census (0) | 2023.08.21 |