select
    round(avg(total.TOTAL_VALUE)) as SA_MEDIAN
from
    (
        select
            *,
            row_number() over(
                order by
                    TOTAL_VALUE desc
            ) as row_num,
            count(1) over() as total_count
        from
            CONVENIENCE
        where
            SURVEY_YEAR = 2019
            and KIND_CODE = '100'
    ) total
where
    total.row_num between total.total_count * 1.0 / 2
    and total.total_count * 1.0 / 2 + 1