with tmp as (
select
    total_value
    ,row_number() over(order by total_value asc) rank
    ,count(*) over(partition by survey_year, kind_code)cnt
from
    convenience
where
    kind_code = '100'
    and survey_year = 2019
)
select
    round(avg(total_value)) "SA_MEDIAN"
from
    tmp
where
    rank between (cnt / 2.0) and (cnt / 2.0 + 1)
;