Find id of candidates whose assessment code is "Pass"?
CREATE TABLE candidate_assessments (candidate_id VARCHAR, asessment_outcome_code VARCHAR)
[SQL] SELECT candidate_id FROM candidate_assessments WHERE asessment_outcome_code = "Pass" [/SQL]