with TARGET as (
    select
        TOTAL_VALUE AS TOTAL_VALUE
    from
        CONVENIENCE
    where
        SURVEY_YEAR = 2019
        and KIND_CODE = "100"
    order by
        TOTAL_VALUE
    limit 2 - (select count(*) % 2 from CONVENIENCE WHERE SURVEY_YEAR = 2019 AND KIND_CODE = "100" )
    offset (select (count(*) - 1) / 2 from CONVENIENCE WHERE SURVEY_YEAR = 2019 AND KIND_CODE = "100" )
)

select
    ROUND(AVG(TOTAL_VALUE)) AS SA_MEDIAN
from
    TARGET