SELECT
 CASE
  WHEN CNT.RECODE_NUM % 2 = 0 THEN 
  (SELECT
   TOTAL_VALUE
  FROM
   VALUE_RECODE
   WHERE
    rownum = CNT.RECODE_NUM /2
    )
  ELSE CNT.RECODE_NUM /2 + 1
END
FROM
(SELECT
   COUNT(CONVENIENCE_tmp.TOTAL_VALUE) AS RECODE_NUM
  FROM
   CONVENIENCE AS CONVENIENCE_tmp
  WHERE
   CONVENIENCE_tmp.SURVEY_YEAR = 2019
  AND
   CONVENIENCE_tmp.KIND_CODE = '100'
) AS CNT,
(SELECT
 TOTAL_VALUE
FROM
 CONVENIENCE
 WHERE
 SURVEY_YEAR = 2019
AND
 KIND_CODE = '100'
ORDER BY
 TOTAL_VALUE ASC) AS VALUE_RECODE