UPDATE total_scores
SET passed =  CASE WHEN total_score >= sub.sum/sub.nin THEN TRUE ELSE FALSE END
FROM (SELECT SUM(total_score) AS sum ,COUNT(total_score) AS nin FROM TOTAL_SCORES) AS sub;
SELECT * FROM total_scores;