We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
  1. Prepare
  2. SQL
  3. Aggregation
  4. Weather Observation Station 19
  5. Discussions

Weather Observation Station 19

Sort by

recency

|

2376 Discussions

|

  • fmunoz1
     + 0 comments
    SELECT
  DECIMAL(
    ROUND(SQRT(POWER(a - c, 2) + POWER(b - d, 2)), 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
);

  • otienophabian200
     + 0 comments

    SELECT CAST(ROUND(SQRT(POWER(min_latn-max_latn,2) + POWER(min_longw-max_longw,2)),4) AS DECIMAL(10,4)) FROM( SELECT MAX(LONG_W) AS max_longw, MAX(LAT_N) AS max_latn, MIN(LONG_W) AS min_longw, MIN(LAT_N) AS min_latn FROM STATION) t ;

  • nurliyanashukur
     + 0 comments
    WITH distance 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
),
cal_eucl_distance AS (
    SELECT 
    SQRT(POWER(min_latn-max_latn, 2)+POWER(min_longw-max_longw,2)) AS eucl_distance
    FROM distance
)

SELECT 
    CAST(eucl_distance AS DECIMAL(10,4))
FROM cal_eucl_distance;

  • tu_anh_anh_81299
     + 0 comments

    SELECT CAST(ROUND(SQRT(POWER(MIN(LAT_N)-MAX(LAT_N),2) + POWER(MIN(LONG_W)-MAX(LONG_W),2)),4) AS DECIMAL(10,4)) FROM STATION

  • srishtirajput201
     + 0 comments

    SELECT ROUND( SQRT( POWER(D-B,2)+ POWER(C-A,2) ) ,4) FROM ( SELECT MIN(LAT_N) AS A, MAX(LAT_N) AS C, MIN(LONG_W) AS B, MAX(LONG_W) AS D FROM STATION

    ) AS COORDINATES;****