with tt as (
    select
        SURVEY_YEAR,
        TOTAL_VALUE,
        rank() over(
            order by
                TOTAL_VALUE,
                PF_CODE
        ) as RANK
    from
        CONVENIENCE
    where
        SURVEY_YEAR == 2019
        and KIND_CODE == "100"
),
t2 as(
    select
        SURVEY_YEAR,
        TOTAL_VALUE
    from
        tt
    limit
        2 - (
            select
                count(*)
            from
                tt
        ) % 2 offset (
            select
                count(*) -1
            from
                tt
        ) / 2
)
select
    round(AVG(TOTAL_VALUE), 0) as SA_MEDIAN
from
    t2
group by
    SURVEY_YEAR