SELECT
    ROUND(AVG(TOTAL_VALUE)) AS SA_MEDIAN
FROM
    (
        SELECT 
            CV1.TOTAL_VALUE
        FROM
            CONVENIENCE AS CV1
            INNER JOIN CONVENIENCE AS CV2
                ON CV2.SURVEY_YEAR = 2019
                AND CV2.KIND_CODE = '100'
        WHERE
            CV1.SURVEY_YEAR = 2019
            AND CV1.KIND_CODE = '100'
        GROUP BY
            CV1.TOTAL_VALUE
        HAVING
            CASE MOD(COUNT(*), 2)
                WHEN 0 THEN SUM(
                    CASE
                        WHEN CV2.TOTAL_VALUE >= CV1.TOTAL_VALUE
                            THEN 1
                        ELSE 0
                        END
                ) >= COUNT(*) / 2
                AND SUM(
                    CASE
                        WHEN CV2.TOTAL_VALUE <= CV1.TOTAL_VALUE
                            THEN 1
                        ELSE 0
                        END
                ) >= COUNT(*) / 2 
                ELSE SUM(
                    CASE
                        WHEN CV2.TOTAL_VALUE >= CV1.TOTAL_VALUE
                            THEN 1
                        ELSE 0
                        END
                ) > COUNT(*) / 2
                AND SUM(
                    CASE
                        WHEN CV2.TOTAL_VALUE <= CV1.TOTAL_VALUE
                        THEN 1
                        ELSE 0
                        END
                ) > COUNT(*) / 2
                END
                
    );