with total_with_rownum as (
    select total_value, row_number() over(
        order by total_value
    ) as n
    from CONVENIENCE
    where survey_year = 2019 and kind_code = '100'
),
row_count as (
    select max(n) as n_max
    from total_with_rownum
),
t as (
    select case when n_max % 2 = 0
            then ( nth_value(total_value, n_max / 2) over(order by total_value)
                + nth_value(total_value, n_max / 2 + 1) over(order by total_value) ) / 2
            else nth_value(total_value, floor(n_max / 2) + 1) over(order by total_value)
        end as sm, n, total_value
    from total_with_rownum
        cross join row_count
)
select max(sm) as SA_MEDIAN
from t