with target as(
    select    
        TOTAL_VALUE
    from
        CONVENIENCE
    where
        SURVEY_YEAR = 2019
        and KIND_CODE = '100'
    order by
        TOTAL_VALUE asc
)
select 
    round(avg(TOTAL_VALUE)) as 'SA_MEDIAN'
from (
    select    
        TOTAL_VALUE
    from
        target
    order by
        TOTAL_VALUE asc
    limit
        2 - (select count(*) from target) % 2
    offset
        (select (count(*) - 1) /2 from target)
)
;