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