Find id of candidates whose assessment code is "Pass"?
create table candidate_assessments (candidate_id varchar, asessment_outcome_code varchar, PRIMARY KEY (candidate_id))
select candidate_id from candidate_assessments where asessment_outcome_code = "pass"