WITH median AS (
SELECT
 *,
 RANK()OVER(ORDER BY TOTAL_VALUE) AS rank
FROM
 CONVENIENCE
WHERE
 SURVEY_YEAR = 2019
AND
 KIND_CODE = '100'
)
SELECT
 CASE
  WHEN MOD(MAX(rank)/2,0) = 1 THEN (SELECT TOTAL_VALUE FROM median WHERE rank = (SELECT ROUND(MAX(rank)/2.0) FROM median))
  ELSE 
  (
  SELECT 
   ROUND(SUM(TOTAL_VALUE)/2.0)
  FROM 
   median 
  WHERE 
   rank = ( SELECT MAX(rank)/2 FROM median)
  OR
   rank = ( SELECT (MAX(rank)/2) + 1 FROM median)
  ) 
 END AS SA_MEDIAN
FROM
 median