-- 合格者のデータを更新
UPDATE total_scores
SET passed = TRUE
WHERE total_score >= (
    SELECT AVG(total_score)
    FROM total_scores
);
-- 不合格者のデータを更新
UPDATE total_scores
SET passed = FALSE
WHERE passed IS NULL;