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 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
        )
    );