CREATE TABLE candidate_assessments (candidate_id VARCHAR, assessment_date VARCHAR)

Find id of the candidate who most recently accessed the course?
SELECT candidate_id FROM candidate_assessments ORDER BY assessment_date DESC LIMIT 1
SELECT "candidate_id" FROM "candidate_assessments" ORDER BY "assessment_date" DESC NULLS LAST LIMIT 1