CREATE TABLE Student_Tests_Taken (registration_id VARCHAR(255), test_result VARCHAR(255)); CREATE TABLE Student_Course_Enrolment (date_of_completion VARCHAR(255), registration_id VARCHAR(255))
What are the completion dates of all the tests that have result "Fail"?
    
SQL: SELECT T1.date_of_completion FROM Student_Course_Enrolment AS T1 JOIN Student_Tests_Taken AS T2 ON T1.registration_id = T2.registration_id WHERE T2.test_result = "Fail"