select round(AVG(TOTAL_VALUE)) 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(*) % 2 FROM (select * 
        from CONVENIENCE
        where SURVEY_YEAR = 2019
        and KIND_CODE = 100)
        ) 
OFFSET (SELECT (COUNT(*) - 1) / 2
        FROM (select * 
        from CONVENIENCE
        where SURVEY_YEAR = 2019
        and KIND_CODE = 100)))