WITH Pre AS(
SELECT
	*
FROM
	CONVENIENCE
WHERE
	SURVEY_YEAR = 2019
AND
	KIND_CODE = '100'
),
Pre2 AS(
SELECT
	TOTAL_VALUE,
	ROW_NUMBER() OVER(ORDER BY TOTAL_VALUE) AS ROW,
	COUNT(*) OVER() AS TOTAL_ROWS
FROM
	Pre),
Pre3 AS(
SELECT
	TOTAL_VALUE AS SCORE
FROM
	Pre2
WHERE
	ROW IN (  (TOTAL_ROWS + 1) / 2, (TOTAL_ROWS + 2) / 2)
)
SELECT
	ROUND(AVG(SCORE),0) AS SA_MEDIAN
FROM
	Pre3