Find id of the candidate who most recently accessed the course?
SELECT candidate_id FROM candidate_assessments ORDER BY assessment_date DESC LIMIT 1
most recently accessed refers to MAX(assessment_date); id of the candidate refers to candidate_id;