SQL错题3

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;