select round(avg(TOTAL_VALUE)) as SA_MEDIAN
from(
select TOTAL_VALUE
from CONVENIENCE
where SURVEY_YEAR = 2019
and KIND_CODE = '100'
order by TOTAL_VALUE
 limit (select 
	case
		 when count(*) % 2 = 0 then 2
		 else  1
	end
  from CONVENIENCE
where SURVEY_YEAR = 2019
and KIND_CODE = '100'
)
offset (
select
	case
		 when count(*) % 2 = 0 then count(*) / 2 - 1
		 else  round(count(*) / 2)
	end
  from CONVENIENCE
where SURVEY_YEAR = 2019
and KIND_CODE = '100' )
)