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