WITH A AS (
SELECT * 
    FROM CONVENIENCE 
    WHERE SURVEY_YEAR = 2019 and KIND_CODE = "100"
    ORDER BY TOTAL_VALUE
),
B AS (
    SELECT *
    FROM A
    LIMIT 2 - (SELECT COUNT(*) FROM A) % 2 
    OFFSET (SELECT (COUNT(*) - 1) / 2
              FROM A)
)
SELECT  ROUND(AVG(TOTAL_VALUE))
FROM B