UPDATE total_scores
SET passed = CASE WHEN total_score >= A.avg THEN TRUE ELSE FALSE END
FROM (
    SELECT avg(total_score) AS avg
    FROM total_scores
) AS A;