WITH C2019 AS
(
    SELECT
        TOTAL_VALUE
    FROM
        CONVENIENCE
    WHERE
        SURVEY_YEAR = 2019
    AND KIND_CODE = '100'
)
SELECT
    ROUND(AVG(TOTAL_VALUE)) AS SA_MEDIAN
FROM
(
    SELECT
        TOTAL_VALUE
    FROM
        C2019
    ORDER BY
        TOTAL_VALUE
    LIMIT
        2 - (SELECT COUNT(*) FROM C2019) % 2
    OFFSET
        (SELECT (COUNT(*) - 1) / 2 FROM C2019)
)