UPDATE total_scores AS TS
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;