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