SELECT
    ROUND(AVG(TOTAL_VALUE)) AS 'SA_MEDIAN'
FROM 
    (SELECT
        TOTAL_VALUE
    FROM CONVENIENCE
    WHERE
        KIND_CODE = '100'
        AND SURVEY_YEAR = 2019
    ORDER BY TOTAL_VALUE
    LIMIT
        2 - (SELECT COUNT(*) FROM CONVENIENCE WHERE KIND_CODE = '100' AND SURVEY_YEAR = 2019) % 2
    OFFSET
        (SELECT (COUNT(*)-1)/2 FROM CONVENIENCE WHERE KIND_CODE = '100' AND SURVEY_YEAR = 2019)
    )