with a as (
    SELECT
        *,
        ROW_NUMBER() OVER (ORDER BY TOTAL_VALUE) AS row_num,
        COUNT(*) OVER () AS total_rows
    FROM
        CONVENIENCE
    where
        SURVEY_YEAR = 2019
        and KIND_CODE = '100'
)
select
    ROUND(AVG(TOTAL_VALUE), 0) AS SA_MEDIAN
from
    a
where
    row_num in (
        (total_rows + 1) / 2,
        (total_rows + 2) / 2
    )