WITH MEDIAN AS (
    SELECT
        TOTAL_VALUE,
        ROW_NUMBER() OVER (
            ORDER BY
                TOTAL_VALUE
        ) as r,
        COUNT(*) OVER () AS n
    FROM
        CONVENIENCE
    WHERE
        SURVEY_YEAR = 2019
        AND KIND_CODE = 100
)
SELECT
    ROUND(AVG(TOTAL_VALUE)) AS SA_MEDIAN
FROM
    MEDIAN
WHERE
    n / 2.0 BETWEEN r - 1
    AND r