SELECT
  ROUND(AVG(TOTAL_VALUE) ,0)
FROM
  ( 
    SELECT
      E1.TOTAL_VALUE 
    FROM
      ( 
        SELECT * 
        FROM
          CONVENIENCE 
        WHERE
          SURVEY_YEAR = '2019' 
          AND KIND_CODE = '100'
      ) AS E1 
      CROSS JOIN ( 
        SELECT
          * 
        FROM
          CONVENIENCE 
        WHERE
          SURVEY_YEAR = '2019' 
          AND KIND_CODE = '100'
      ) AS E2 
    GROUP BY
      E1.TOTAL_VALUE 
    HAVING
      SUM( 
        CASE 
          WHEN E1.TOTAL_VALUE >= E2.TOTAL_VALUE 
            THEN 1 
          ELSE 0 
          END
      ) >= COUNT(*) / 2 
      AND SUM( 
        CASE 
          WHEN E1.TOTAL_VALUE <= E2.TOTAL_VALUE 
            THEN 1 
          ELSE 0 
          END
      ) >= COUNT(*) / 2
  ) AS TMP