Weather Observation Station 18

  • + 0 comments

    select round((abs(a-c)+abs(b-d)),4) from( select (select min(lat_n) from station) as a, (select min(long_w) from station) as b, (select max(lat_n) from station) as c, (select max(long_w) from station) as d ) as t;

    if you want to do by defing each variable, otherwise u can use manhattan formula directly.