with temp as (
    select
        PF_CODE,TOTAL_VALUE
    from
        CONVENIENCE
    where
        KIND_CODE='100'
        and
        SURVEY_YEAR='2019'
    ), temp2 as (
    select
        PF_CODE,TOTAL_VALUE, (select count(*) from temp as t0 where t0.TOTAL_VALUE<=t.TOTAL_VALUE) as num, (select count(*) from temp) as tnum
    from
        temp as t
    )
    select
        round(avg(TOTAL_VALUE)) as SA_MEDIAN
    from
        temp2
    where
        tnum%2=0 and (cast(tnum/2 as integer)=num or cast(tnum/2 as integer)+1=num)
        or
        tnum%2<>0 and cast(tnum/2 as integer)+1=num