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;