SELECT count(*) FROM Student_Tests_Taken WHERE test_result  =  "Fail"
Count the number of tests with "Fail" result.
SELECT count ( * ) FROM Student_Tests_Taken WHERE test_result = `` Fail ''
select count ( * ) from student_tests_taken where test_result = value
Count the number of tests with `` Fail '' result .