with SUB as (
    select
        TOTAL_VALUE,
        row_number() over (
            order by
                TOTAL_VALUE
        ) as ROW_ID,
        (
            select
                count(TOTAL_VALUE)
            from
                CONVENIENCE
            where
                SURVEY_YEAR = 2019
                and KIND_CODE = "100"
        ) as COUNT
    from
        CONVENIENCE
    where
        SURVEY_YEAR = 2019
        and KIND_CODE = "100"
)
select
    round(avg(TOTAL_VALUE)) as SA_MEDIAN
from
    SUB
where
    ROW_ID between COUNT / 2.0
    and COUNT / 2.0 + 1