select
    round(avg(TOTAL_VALUE))
from (
    select
        c1.TOTAL_VALUE
    from
        CONVENIENCE as c1
        cross join CONVENIENCE as c2
    where
        c1.SURVEY_YEAR = 2019
        and c2.SURVEY_YEAR = 2019
        and c1.KIND_CODE = 100
        and c2.KIND_CODE = 100
    group by
        c1.TOTAL_VALUE
    having
        sum(case when c1.TOTAL_VALUE >= c2.TOTAL_VALUE then 1 else 0 end) >= count(*) / 2
        and sum(case when c1.TOTAL_VALUE <= c2.TOTAL_VALUE then 1 else 0 end) >= count(*) / 2
)