How many tests have result "Fail"?
select count(*) from student_tests_taken where test_result = "Fail"