UPDATE total_scores
SET passed = CASE
WHEN total_score >= (
    SELECT AVG(total_score) AS AVE FROM total_scores
)
THEN TRUE
ELSE FALSE
END