yes | Here are all the candidates' ids who got assessed. | which of those most recently had an assessment?
SELECT candidate_id FROM candidate_assessments ORDER BY assessment_date DESC LIMIT 1
most recently had an assessment refers to MAX(assessment_date);