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