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

UPDATE total_scores
    SET passed = FALSE
    WHERE passed IS NULL;