select ROUND(avg(TOTAL_VALUE), 0) AS SA_MEDIAN
 from (select
        TOTAL_VALUE from CONVENIENCE order by TOTAL_VALUE LIMIT 2 OFFSET (SELECT (COUNT(*) - 1) / 2 FROM CONVENIENCE)
        );