select round(AVG(TOTAL_VALUE)) as SA_MEDIAN from (
select *--AVG(TOTAL_VALUE) as aaa
from CONVENIENCE
where SURVEY_YEAR = 2019
  and KIND_CODE = 100
order by TOTAL_VALUE 
LIMIT 2- (SELECT COUNT(*) FROM (select * 
        from CONVENIENCE
        where SURVEY_YEAR = 2019
        and KIND_CODE = 100)
        ) % 2
OFFSET (SELECT (COUNT(*) - 1) / 2
        FROM (select * 
        from CONVENIENCE
        where SURVEY_YEAR = 2019
        and KIND_CODE = 100)))