Weather Observation Station 18

  • + 0 comments

    SQL Server :

    with cte as(
        select min(LAT_N) as a, min(LONG_W) b, max(LAT_N) as c, max(LONG_W) as d from station
    ), cte1 as(
            select (c-a) as p1, (d-b) as p2 from cte
        )
    select cast(round(abs(p1+p2), 4) as decimal(10,4)) from cte1;