Weather Observation Station 18

  • + 0 comments
    SELECT
      DECIMAL(
        ROUND(ABS(a - c) + ABS(b - d), 4),
        10, 4
      )
    FROM (
      SELECT
        MIN(lat_n) AS a,
        MIN(long_w) AS b,
        MAX(lat_n) AS c,
        MAX(long_w) AS d
      FROM Station
    );