UPDATE total_scores
SET passed = TRUE
WHERE total_score >= (
    SELECT AVG(total_score)
    FROM total_scores
);

UPDATE total_scores
SET passed = FALSE
WHERE total_score < (
    SELECT AVG(total_score)
    FROM total_scores
);

SELECT * FROM total_scores;