SELECT ROUND(LONG_W,4)

FROM station

WHERE LAT_N<137.2345

ORDER BY LAT_NDESC

LIMIT1;

SELECT ROUND(LAT_N,4)

FROM station

WHERE LAT_N>38.7880

ORDER BY LAT_NASC

LIMIT1;

SELECT ROUND(LONG_W,4)

FROM station

WHERE LAT_N>38.7880

ORDER BY LAT_NASC

LIMIT1;

Consider P1(a, b) and P2(c,d) to be two points on a 2D plane.

- a - happens to equal the minimum value in Northern Latitude (LAT_N in STATION).

- b - happens to equal the minimum value in Western Longitude (LONG_W in STATION).

- c - happens to equal the maximum value in Northern Latitude (LAT_N in STATION).

- d - happens to equal the maximum value in Western Longitude (LONG_W in STATION).

Query the Manhattan Distance between points P1 and P2 and round it to a scale of 4 decimal places.

ROUND(

ABS(MIN(LAT_N)-MAX(LAT_N))+ ABS(MIN(LONG_W)-MAX(LONG_W)),

)AS manhattan_distance

station;

Consider P1(a, c) and P2(b, d) to be two points on a 2D plane where (a,b) are the respective minimum and maximum values of Northern Latitude (LAT_N) and (c, d) are the respective minimum and maximum values of Western Longitude (LONG_W) in STATION.

Query the Euclidean Distance between points P1 and P2 and round it to a scale of 4 decimal places.

ROUND(

SQRT(POW(MIN(LAT_N)-MAX(LAT_N),2)+ POW(MIN(LONG_W)-MAX(LONG_W),2)),

)AS euclidean_distance

station;

WITH OrderedLatitudesAS (

SELECT LAT_N

FROM station

ORDER BY LAT_N

),

RowNumberedAS (

SELECT LAT_N, ROW_NUMBER() OVER ()AS row_num

FROM OrderedLatitudes

),

CountedAS (

SELECTCOUNT(*)AS total_count

FROM station

)

SELECT ROUND(

CASE

WHEN total_count %2=1 THEN

(SELECT LAT_NFROM RowNumberedWHERE row_num= (total_count+1)/2)

ELSE

(SELECTAVG(LAT_N)

FROM RowNumbered

WHERE row_numIN (total_count/2, total_count/2+1))

END,

)AS median_lat_n

FROM Counted;