UPDATE TOTAL_SCORES
SET PASSED = CASE WHEN TOTAL_SCORE > (SELECT AVG(TOTAL_SCORE) FROM TOTAL_SCORES) THEN TRUE ELSE FALSE END;