SELECT
    AVG(VALUE) AS SA_MEDIAN
FROM
    (
        SELECT
            A.VALUE
        FROM
            (
                SELECT
                    TOTAL_VALUE AS VALUE
                    ,COUNT(TOTAL_VALUE) AS CNT
                FROM
                    CONVENIENCE
                WHERE
                    SURVEY_YEAR = '2019'
                    AND KIND_CODE = '100'
            ) AS A
        CROSS JOIN
            (
                SELECT
                    TOTAL_VALUE AS VALUE
                    ,COUNT(TOTAL_VALUE) AS CNT
                FROM
                    CONVENIENCE
                WHERE
                    SURVEY_YEAR = '2019'
                    AND KIND_CODE = '100'
            ) AS B
        GROUP BY
            A.VALUE
        HAVING
            SUM(CASE WHEN A.VALUE >= B.VALUE THEN 1 ELSE 0 END) >= count(*) / 2
        AND SUM(CASE WHEN A.VALUE <= B.VALUE THEN 1 ELSE 0 END) >= count(*) / 2
    ) AS TBL