Query the median of the Northern Latitudes (LAT_N) from STATION and round your answer to 4 decimal places.
SELECT
ROUND(AVG(DISTINCT LAT_N),4)
FROM (
SELECT LAT_N, ROW_NUMBER() OVER (ORDER BY LAT_N) AS RNK
FROM STATION
) AS TEMP
WHERE RNK IN ( (SELECT CEIL(COUNT(*)/2.0) FROM STATION),
(SELECT CEIL((COUNT(*)/2.0)+0.1) FROM STATION) );
SELECT
ROUND(
AVG(LAT_N * 1.0),
4
) AS Median
FROM (
SELECT
LAT_N,
ROW_NUMBER() OVER (ORDER BY LAT_N) AS RowAsc,
ROW_NUMBER() OVER (ORDER BY LAT_N DESC) AS RowDesc
FROM STATION
) AS Subquery
WHERE RowAsc = RowDesc OR RowAsc + 1 = RowDesc OR RowAsc = RowDesc + 1;