Weather Observation Station 20

  • + 0 comments
    WITH Lati_Table AS (
      SELECT LAT_N, ROW_NUMBER() OVER(ORDER BY LAT_N ASC) as row_num,
             COUNT(*) OVER() as total_count
      FROM STATION
    )SELECT ROUND(LAT_N,4) FROM Lati_Table WHERE row_num = (total_count+1)/2;