Median MySQL

WITH ranked AS (
    SELECT lat_n,
    row_number() over(order by lat_n) as id
    from station
)

SELECT ROUND(lat_n,4)
FROM ranked
WHERE id = (SELECT CEIL(COUNT(*)/2) FROM station);