WITH
PRE_MEDIAN AS (
    SELECT
        TOTAL_VALUE
    FROM
        CONVENIENCE
    WHERE
        SURVEY_YEAR = 2019
        AND KIND_CODE = 100
    ORDER BY
        TOTAL_VALUE ASC
    LIMIT
        2 - (SELECT COUNT(*) % 2 FROM CONVENIENCE WHERE SURVEY_YEAR = 2019 AND KIND_CODE = 100)
    OFFSET
        (SELECT (COUNT(*)-1) / 2 FROM CONVENIENCE WHERE SURVEY_YEAR = 2019 AND KIND_CODE = 100)
)

SELECT
    ROUND(AVG(TOTAL_VALUE)) AS SA_MEDIAN
FROM
    PRE_MEDIAN
;