select
    cast(avg(TOTAL_VALUE) as integer) as SA_MEDIAN
from
(
select
    TOTAL_VALUE
    ,row_number() over(partition by '' order by TOTAL_VALUE) as RN
    ,row_number() over(partition by '' order by TOTAL_VALUE)+0.5 as RN01
    ,row_number() over(partition by '' order by TOTAL_VALUE)-0.5 as RN02
from
    CONVENIENCE
where
    SURVEY_YEAR='2019'
    and KIND_CODE='100'
    and TOTAL_VALUE<>0
) SUB
where
    RN in (select cast( count(*) as real)/2 from CONVENIENCE where SURVEY_YEAR='2019' and KIND_CODE='100' and TOTAL_VALUE<>0)
    or 
    RN01 in (select cast( count(*) as real)/2 from CONVENIENCE where SURVEY_YEAR='2019' and KIND_CODE='100' and TOTAL_VALUE<>0)
    or
    RN02 in (select cast( count(*) as real)/2 from CONVENIENCE where SURVEY_YEAR='2019' and KIND_CODE='100' and TOTAL_VALUE<>0)