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
);