What is the oldest date of assessment of the candidates?
select assessment_date from candidate_assessments order by assessment_date asc limit 1
Most recent?
select assessment_date from candidate_assessments order by assessment_date desc limit 1
Give the candidate id instead.
select candidate_id from candidate_assessments order by assessment_date desc limit 1