with t1 as(
select TOTAL_VALUE, row_number() over (order by TOTAL_VALUE) as rank
from CONVENIENCE
where SURVEY_YEAR = 2019 and KIND_CODE = '100'
)
select 
    ROUND(AVG(TOTAL_VALUE)) AS SA_MEDIAN
from t1 -- 35
where rank between (
    select floor(max(rank) * 1.0 / 2) from t1
    ) and (
    select floor(max(rank) * 1.0 / 2 + 1) from t1
    )