with sub as (
    select TOTAL_VALUE from CONVENIENCE where SURVEY_YEAR = 2019 and KIND_CODE = '100' order by TOTAL_VALUE desc
), avg as(
    select
        TOTAL_VALUE
    from 
        sub
    limit (select case when (select count(*) from sub) % 2 = 0 then 2 else 1 end)
    offset (select count(*)/2 from sub) + (select case when (select count(*) from sub) % 2 = 0 then -1 else 0 end)
)
select 
    round(avg(TOTAL_VALUE),0) as SA_MEDIAN
from 
    avg
;