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 asc
    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')
);