CREATE TABLE Student_Tests_Taken (test_result VARCHAR)

How many tests have result 'Fail'?
SELECT COUNT(*) FROM Student_Tests_Taken WHERE test_result = "Fail"
SELECT COUNT(*) FROM "Student_Tests_Taken" WHERE "Fail" = "test_result"