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(*) % 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)
);