Weather_Observation_Station_20.sql

/* A median is defined as a number separating the higher half of a data set from the lower half. 
 Query the median of the Northern Latitudes (LAT_N) from STATION and round your answer to 4 decimal places. */

SELECT ROUND(S.LAT_N, 4)
FROM station AS S
WHERE (
        SELECT COUNT(Lat_N)
        from station
        WHERE Lat_N < S.LAT_N
    ) = (
        SELECT COUNT(Lat_N)
        FROM station
        WHERE Lat_N > S.LAT_N
    );