select
    round(avg(tmp.TOTAL_VALUE)) as SA_MEDIAN
from (
    select
        TOTAL_VALUE,
        rank() over (order by TOTAL_VALUE) seq,
        count(1) over (partition by SURVEY_YEAR, KIND_CODE) count
    from
        CONVENIENCE
    where
        SURVEY_YEAR = 2019
        and
        KIND_CODE = '100'
) as tmp
where
    tmp.seq between count / cast(2 as real) and count / cast(2 as real) + 1;