with a as (
select TOTAL_VALUE , ROW_NUMBER() OVER (
                PARTITION BY SURVEY_YEAR
                ORDER BY
                    TOTAL_VALUE
            ) AS ROWNUM
    from CONVENIENCE where SURVEY_YEAR = 2019 and KIND_CODE = 100),
    
b as (select *, (select max(ROWNUM) from a) as m from a)
-- select * from b
select round(avg(TOTAL_VALUE) ) as SA_MEDIAN from b
where m / 2 <= ROWNUM and ROWNUM <= m / 2 + 1