Find id of candidates whose assessment code is "Pass"?
SELECT candidate_id FROM candidate_assessments WHERE asessment_outcome_code = "Pass"
candidates whose assessment outcome is Pass refers to asessment_outcome_code = 'Pass'; finding id refers to SELECT candidate_id;