SELECT
    ROUND(AVG(VALUE),0) AS SA_MEDIAN
FROM
    (
        SELECT
            A.VALUE
        FROM
            (
                SELECT
                    TOTAL_VALUE AS VALUE
                FROM
                    CONVENIENCE
                WHERE
                    SURVEY_YEAR = '2019'
                    AND KIND_CODE = '100'
                ORDER BY
                    VALUE DESC
            ) AS A
        CROSS JOIN
            (
                SELECT
                    TOTAL_VALUE AS VALUE
                FROM
                    CONVENIENCE
                WHERE
                    SURVEY_YEAR = '2019'
                    AND KIND_CODE = '100'
                ORDER BY
                    VALUE DESC
            ) 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