select ROUND(AVG(WORK.TOTAL_VALUE),0) 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 P_KIND_CODE
        FROM
            CONVENIENCE
        where SURVEY_YEAR = '2019' and KIND_CODE = '100'
    ) WORK
where
    WORK.ROWNUM BETWEEN WORK.P_KIND_CODE * 1.0 / 2
    AND WORK.P_KIND_CODE * 1.0 / 2 + 1
GROUP BY
    WORK.KIND_CODE;