Weather Observation Station 20

  • + 0 comments
    WITH cte AS (
        SELECT LAT_N,
            COUNT(*) OVER () AS n,
            ROW_NUMBER() OVER (ORDER BY LAT_N) AS rn
        FROM STATION
    )
    SELECT ROUND(AVG(LAT_N), 4) FROM cte
    WHERE rn=(n+1)/2 OR rn=(n+2)/2