What is the latest test completion date?
SELECT T1.date_of_completion FROM Student_Course_Enrolment AS T1 JOIN Student_Tests_Taken AS T2 ON T1.registration_id   =   T2.registration_id order by T1.date_of_completion desc limit 1
latest test completion date refers to MAX(date_of_completion);