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(*) from convenience where kind_code ='100' and survey_year='2019' )%2
offset ((select count(*) from convenience where kind_code ='100' and survey_year='2019' )-1)/2)