WITH
wk_list(numall, TOTAL_VALUE)
AS
	(
	--TOTAL_VALUEの降順と連番
	select
		(
		select count(*)
		from
			CONVENIENCE
		where
			SURVEY_YEAR = '2019'
			and KIND_CODE = '100'
			and (TOTAL_VALUE) >= x.TOTAL_VALUE
		) as CNT
		,TOTAL_VALUE
	from
		CONVENIENCE x
	where
		SURVEY_YEAR = '2019'
		and KIND_CODE = '100'
	order by
		TOTAL_VALUE desc
	)

select ROUND(AVG(TOTAL_VALUE)) as SA_MEDIAN
from
	(
	select
		TOTAL_VALUE
	from wk_list
	limit 2 - (select count(*) from wk_list) % 2
	OFFSET (select (count(*) - 1) / 2 from wk_list)
	)