You are viewing a single comment's thread. Return to all comments →
with cte as (
select min(lat_n) as a,min(long_w)as b , max(lat_n) as c, max(long_w) as d
from station ) ,int_result as (select -1*(a-c) as g ,-1*(b-d) as f from cte as x)
select cast(g+f as decimal(7,4)) from int_result
Seems like cookies are disabled on this browser, please enable them to open this website
Weather Observation Station 18
You are viewing a single comment's thread. Return to all comments →
with cte as (
from station ) ,int_result as (select -1*(a-c) as g ,-1*(b-d) as f from cte as x)
select cast(g+f as decimal(7,4)) from int_result