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

SELECT * FROM total_scores;