with WORK as (
    select
        *,
        row_number() over(
            order by total_value desc
        ) as rownum,
        count(*) over (partition by kind_code) as count
    from
        convenience
    where
        survey_year = '2019' and
        kind_code = '100'
)
select
    round(avg(total_value)) as SA_MEDIAN
from
    work
where
    rownum between count * 1.0 / 2 and count * 1.0 / 2 + 1