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;