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