Weather Observation Station 20

  • + 0 comments
    with tmp as (
        select lat_n
        , row_number() over () as num
        from station
        order by lat_n
    )
    select round(lat_n, 4) 
    from tmp
    where num = (select max(num) from tmp) div 2 + 1