with tmp as(
select TOTAL_VALUE
  from CONVENIENCE
 where SURVEY_YEAR = 2019
   and KIND_CODE = '100')
select round(avg(TOTAL_VALUE)) as SA_MEDIAN
from (select TOTAL_VALUE,
      count(*) over() as RecCnt,
      Row_Number() over(order by TOTAL_VALUE) as Rn
        from tmp)
 where mod(RecCnt,2) = 0 and Rn in(RecCnt/2,RecCnt/2+1)
    or mod(RecCnt,2) = 1 and Rn = Ceil(RecCnt/2.0)