Task: Text to Code
Input (English): Step 1: For each row in Student_Course_Enrolment table, find the corresponding rows in Student_Tests_Taken table.
Step 2: find date_of_enrolment, test_result of the results of step 1
Output (English): SELECT T1.date_of_enrolment , T2.test_result FROM Student_Course_Enrolment AS T1 JOIN Student_Tests_Taken AS T2 ON T1.registration_id = T2.registration_id