UPDATE total_scores
    SET passed = TRUE
    WHERE total_score >= (
        SELECT 
            avg(total_score) 
        FROM total_scores 
        WHERE test_code = 'T00001'
        GROUP BY test_code
    );
UPDATE total_scores
    SET passed = FALSE
    WHERE passed IS NULL;