Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM Courses WHERE course_name = "Fail"
Feedback: find the number of rows in student tests taken table whose test result equals Fail .
Output (English): SELECT count(*) FROM Student_Tests_Taken WHERE test_result  =  "Fail"