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

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