What is the 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 = MAX(assessment_date); id of the candidate = candidate_id;