WITH TMP AS (
    SELECT
        TOTAL_VALUE,
        RANK() OVER(
            ORDER BY
                TOTAL_VALUE DESC
        ) AS RANK
    FROM
        CONVENIENCE
    WHERE
        SURVEY_YEAR = '2019'
        AND KIND_CODE = '100'
)
SELECT
    SA_MEDIAN
FROM
    (
        SELECT
            CASE
                TOTAL_VALUE
                WHEN (
                    SELECT
                        COUNT(*)
                    FROM
                        TMP
                ) % 2 = 0 THEN (
                    SELECT
                        ROUND(AVG(TOTAL_VALUE))
                    FROM
                        TMP
                    WHERE
                        RANK IN (
                            (
                                SELECT
                                    COUNT(*)
                                FROM
                                    TMP
                            ) / 2,
                            (
                                SELECT
                                    COUNT(*)
                                FROM
                                    TMP
                            ) / 2 - 1
                        )
                )
                ELSE(
                    SELECT
                        TOTAL_VALUE
                    FROM
                        TMP
                    WHERE
                        RANK = (
                            (
                                SELECT
                                    COUNT(*)
                                FROM
                                    TMP
                            ) / 2
                        )
                )
            END AS SA_MEDIAN
        FROM
            TMP
    )
LIMIT
    1;