-- 合格者のデータを更新
update total_scores
set
    passed=true
where
    total_score >= (
        select
            avg(total_score)
        from total_scores
    );

-- 不合格者のデータを更新
update total_scores
set
    passed=false
where
    total_score < (
        select
            avg(total_score)
        from total_scores
    );