SELECT
    ROUND(AVG(TOTAL_VALUE)) AS SA_MEDIAN
FROM
    (
        SELECT
            CV1.TOTAL_VALUE
            ,COUNT(*)
        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
    );