select 
    round(avg(TOTAL_VALUE)) as SA_MEDIAN
/*
,MOD(cnt, 2)
,CAST(cnt/2 as int)
,(CAST(cnt/2 as int)+1)
,ran1
*/
from 
(
    select 
        TOTAL_VALUE,
        (select count(TOTAL_VALUE) from CONVENIENCE where SURVEY_YEAR='2019' and KIND_CODE='100' ) cnt,
        rank() OVER(ORDER BY TOTAL_VALUE DESC) ran1
    from 
        CONVENIENCE
    where 
        SURVEY_YEAR='2019'
    and KIND_CODE='100'
 ) 
where 
(
    MOD(cnt, 2)= 0 and CAST(cnt/2 as int) = ran1
    or
    CAST(cnt/2 as int)+1 = ran1
)