with tmp as(
select TOTAL_VALUE,
Row_Number() over(order by TOTAL_VALUE) as Rank,
count(*) over() as RecordCount
  from CONVENIENCE
where SURVEY_YEAR = 2019
  and KIND_CODE = '100')
select round(avg(TOTAL_VALUE)) as SA_MEDIAN
  from tmp
 where abs(2*Rank - RecordCount - 1) <= 1