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