SELECT count(*) FROM Student_Tests_Taken WHERE test_result  =  "Fail"
How many tests have result "Fail"?
SELECT count ( * ) FROM Student_Tests_Taken WHERE test_result = `` Fail ''
select count ( * ) from student_tests_taken where test_result = value
How many tests have result `` Fail '' ?