which of those most recently had an assessment?
select candidate_id from candidate_assessments order by assessment_date desc limit 1