with FILTERED_CONVENIENCE_WITH_ROW_NUMBER as (
    with FILTERED_CONVENIENCE as (
        select
            *
        from
            CONVENIENCE
        where
            1 = 1
            and SURVEY_YEAR = 2019
            and KIND_CODE = '100'
    ) 

    select
        row_number() over (
            order by
                TOTAL_VALUE
        ) as row_number,
        FILTERED_CONVENIENCE.TOTAL_VALUE,
        (
            select
                count(*)
            from
                FILTERED_CONVENIENCE
        ) as count
    from
        FILTERED_CONVENIENCE
)

select
    round(avg(TOTAL_VALUE)) as SA_MEDIAN
from
    FILTERED_CONVENIENCE_WITH_ROW_NUMBER
where
    1 = 1
    and row_number between count / 2.0 and count / 2.0 + 1