UPDATE total_scores
SET passed = 'TRUE'
WHERE TOTAL_SCORE >= (SELECT AVG(TOTAL_SCORE) AS AVE FROM TOTAL_SCORES);

UPDATE TOTAL_SCORES
SET PASSED = 'FALSE'
WHERE TOTAL_SCORE < (SELECT AVG(TOTAL_SCORE) AS AVE FROM TOTAL_SCORES);