Weather Observation Station 18

  • + 0 comments
    WITH TotalManDis AS (
        select 
            MIN(LAT_N) AS min_latn,
            MIN(LONG_W) AS min_longW,
            MAX(LAT_N) AS max_latn,
            MAX(LONG_W) AS max_longw
        from STATION
    )
    SELECT 
        CAST(ABS(min_latn - max_latn) + ABS(min_longW - max_longw) AS DECIMAL(10,4))
    FROM TotalManDis;