Weather Observation Station 18

  • + 0 comments

    Oracle sample with cte for readability

    WITH ps AS ( 
        SELECT
            min(lat_n) P1a, 
            min(long_w) P1b, 
            max(lat_n) P2c, 
            max(long_w) P2d 
        FROM station)
    SELECT
        round((p2c -p1a) +(p2d-p1b),4) manhattan_distance
    FROM ps
    ;