select
    round(avg(total_value)) as SA_MEDIAN
from (
select 
    total_value
from
    convenience
where
    survey_year = 2019
    and kind_code = "100"
order by 1
limit 2 - (
    select COUNT(*) 
    from convenience
    where survey_year = 2019 and kind_code = "100"
) % 2
offset (
    select round((COUNT(*) - 1) / 2)
    from convenience
    where survey_year = 2019 and kind_code = "100"
    )
)t1