Find id of the candidate who most recently accessed the course?
create table candidate_assessments (candidate_id varchar, assessment_date varchar, PRIMARY KEY (candidate_id))
select candidate_id from candidate_assessments order by assessment_date desc limit 1