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