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;
SELECT * FROM total_scores;