SELECT
    ROUND(AVG(WORK.TOTAL_VALUE)) AS MEDIAN
FROM
    (
        SELECT
            *,
            ROW_NUMBER() OVER (
                PARTITION BY PF_CODE
                ORDER BY
                    TOTAL_VALUE
            ) AS ROWNUM,
            COUNT(1) OVER(PARTITION BY 	PF_CODE) AS TOTAL_PF
        FROM
            CONVENIENCE
        where
            SURVEY_YEAR = 2019
            and KIND_CODE = '100'
    ) WORK
WHERE
    WORK.ROWNUM BETWEEN WORK.TOTAL_PF * 1.0 / 2
    AND WORK.TOTAL_PF * 1.0 / 2 + 1