SELECT ROUND(AVG(TOTAL_VALUE)) AS SA_MEDIAN
FROM CONVENIENCE
WHERE (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')
        );