Find id of candidates whose assessment code is "Pass"?
CREATE TABLE candidate_assessments (candidate_id VARCHAR, asessment_outcome_code VARCHAR)
SELECT candidate_id FROM candidate_assessments WHERE asessment_outcome_code = "Pass"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE candidate_assessments (candidate_id VARCHAR, asessment_outcome_code VARCHAR) Question: Find id of candidates whose assessment code is "Pass"? [/INST] SELECT candidate_id FROM candidate_assessments WHERE asessment_outcome_code = "Pass" </s>