Find id of candidates whose assessment code is "Pass"?
select candidate_id from candidate_assessments where asessment_outcome_code = "Pass"