Find id of the candidate who most recently accessed the course?
CREATE TABLE candidate_assessments (candidate_id VARCHAR, assessment_date VARCHAR)
SELECT TOP 1 candidate_id FROM candidate_assessments ORDER BY assessment_date DESC
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE candidate_assessments (candidate_id VARCHAR, assessment_date VARCHAR) Question: Find id of the candidate who most recently accessed the course? [/INST] SELECT TOP 1 candidate_id FROM candidate_assessments ORDER BY assessment_date DESC </s>