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 CASE MOD(cnt, 2) WHEN 0 THEN CAST(cnt/2 as int) = ran1 or (CAST(cnt/2 as int)+1) = ran1
else CAST(cnt/2 as int)+1 = ran1 END