SELECT
    round(AVG(tmp.TOTAL_VALUE)) AS MEDIAN
FROM
    (
        SELECT
            *,
            ROW_NUMBER() OVER (
                ORDER BY
                    TOTAL_VALUE
            ) AS ROWNUM,
            COUNT(1) over() AS total_cnt
        FROM
            convenience
        WHERE survey_year = 2019 and KIND_CODE = '100'
    ) tmp
WHERE
    tmp.ROWNUM BETWEEN tmp.total_cnt * 1.0 / 2
    AND tmp.total_cnt * 1.0 / 2 + 1