SELECT
ROUND(
    ((
        SELECT
            TOTAL_VALUE
        FROM
            CONVENIENCE C
        WHERE
            KIND_CODE = '100'
        AND
            SURVEY_YEAR = '2019'
        ORDER BY
            TOTAL_VALUE ASC
        LIMIT
            1
        OFFSET (
            SELECT
                ROUND((COUNT(*) + 1) / 2)
            FROM
                CONVENIENCE C
            WHERE
                KIND_CODE = '100'
                AND
                SURVEY_YEAR = '2019'
        )
    )
    +
    (
        SELECT
            TOTAL_VALUE
        FROM
            CONVENIENCE C
        WHERE
            KIND_CODE = '100'
        AND
            SURVEY_YEAR = '2019'
        ORDER BY
            TOTAL_VALUE ASC
        LIMIT
            1
        OFFSET (
            SELECT
                FLOOR((COUNT(*) + 1) / 2)
            FROM
                CONVENIENCE C
            WHERE
                KIND_CODE = '100'
                AND
                SURVEY_YEAR = '2019'
        )
    ))
    / 2
) SA_MEDIAN