SELECT
    ROUND(AVG(TOTAL_VALUE)) AS SA_MEDIAN
FROM
    (
        SELECT
            TOTAL_VALUE
        FROM
            CONVENIENCE
        WHERE
            SURVEY_YEAR = 2019
            AND KIND_CODE = '100'
        ORDER BY
            TOTAL_VALUE
        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'
            )
    );