We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
using cte in MySQL:
with cte
as
(
select
sum(LAT_N) as lat_n
,sum(LONG_W) as long_w
from STATION
)
select
round(cte.lat_n,2)
,round(cte.long_w,2)
from cte;
Cookie support is required to access HackerRank
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 2
You are viewing a single comment's thread. Return to all comments →
using cte in MySQL: with cte as ( select sum(LAT_N) as lat_n ,sum(LONG_W) as long_w from STATION ) select round(cte.lat_n,2) ,round(cte.long_w,2) from cte;