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(
                            (
                                (SELECT TOTAL_VALUE TMP WHERE RANK = ((
                                    SELECT
                                        COUNT(*)
                                    FROM
                                        TMP
                                ) / 2)) 
                                + 
                                (SELECT TOTAL_VALUE TMP WHERE RANK = ((
                                    SELECT
                                        COUNT(*)
                                    FROM
                                        TMP
                                ) / (2 -1))
                                )
                            ) / 2
                        )
                    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;