select round(AVG(tmp.TOTAL_VALUE)) AS SA_MEDIAN from 
(select
*,
ROW_NUMBER() OVER (
    PARTITION BY KIND_CODE
    ORDER BY
    TOTAL_VALUE
    ) AS ROWNUM,
COUNT(1) OVER(PARTITION BY KIND_CODE) AS TOTAL_NUM
from CONVENIENCE where SURVEY_YEAR = 2019
) as tmp
WHERE
    tmp.ROWNUM BETWEEN tmp.TOTAL_NUM * 1.0 / 2
    AND tmp.TOTAL_NUM * 1.0 / 2 + 1
    AND KIND_CODE='100'
GROUP BY
    tmp.KIND_CODE;