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) + 0.1) as SA_MEDIAN from b
where m / 2 <= ROWNUM and ROWNUM <= m / 2 + 1