select round(avg(total_value)) as SA_MEDIAN
from (
        select 
            c1.total_value
        from convenience c1
        inner join convenience c2
            on c2.survey_year=2019
            and c2.kind_code='100'
        where 
            c1.survey_year=2019
            and c1.kind_code='100'
        group by c1.total_value
        having case mod(count(*),2) when 0 then sum(case when c2.total_value>=c1.total_value then 1 else 0 end)>=count(*)/2
                                            and sum(case when c2.total_value<=c1.total_value then 1 else 0 end)>=count(*)/2
                                    else sum(case when c2.total_value>=c1.total_value then 1 else 0 end)>count(*)/2
                                    and  sum(case when c2.total_value<=c1.total_value then 1 else 0 end)>count(*)/2 
                                    end
    );