UPDATE TOTAL_SCORES AS TS1
SET PASSED = 'TRUE'
WHERE TS1.TOTAL_SCORE >= 
(SELECT AVG(T1.TOTAL_SCORE)
FROM TOTAL_SCORES AS T1
WHERE T1.TEST_CODE = 'T00001'
) 
AND TS1.TEST_CODE = 'T00001';

UPDATE TOTAL_SCORES AS TS1
SET PASSED = 'FALSE'
WHERE TS1.PASSED = NULL
AND TS1.TEST_CODE = 'T00001'