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