UPDATE TOTAL_SCORES AS TS
SET PASSED = (
    CASE WHEN TOTAL_SCORE < SUB.AVG_SCORE THEN TRUE
    ELSE FALSE END
)
FROM (
    SELECT AVG(TOTAL_SCORE) AS AVG_SCORE
    FROM TOTAL_SCORES
) AS SUB;