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
    TOTAL_VALUE
from
    temp2
where
    cast(tnum/2 as integer)=num