WITH RANK_AMOUNT AS
(
    SELECT
        RANK() OVER(ORDER BY TOTAL_VALUE DESC) AS RANK,
        TOTAL_VALUE
    FROM
        CONVENIENCE
    WHERE
        SURVEY_YEAR = 2019
    AND KIND_CODE = '100'
),
RANK_POINT AS
(
    SELECT
        MAX(RANK) / 2 AS SU_1,
        MAX(RANK) / 2 + 1 AS SU_2
    FROM
        RANK_AMOUNT
)
SELECT
    ROUND(CAST((RANK_1.TOTAL_VALUE + RANK_2.TOTAL_VALUE) AS DOUBLE) / CAST(2 AS DOUBLE), 0) AS SA_MEDIAN
FROM
    RANK_POINT
    INNER JOIN
    RANK_AMOUNT AS RANK_1
    ON RANK_POINT.SU_1 = RANK_1.RANK
    INNER JOIN
    RANK_AMOUNT AS RANK_2
    ON RANK_POINT.SU_2 = RANK_2.RANK
;