Count the number of tests with "Fail" result.
select count(*) from student_tests_taken where test_result = "Fail"