What are the ids of the candidates that have an outcome code of Pass?
SELECT candidate_id FROM candidate_assessments WHERE asessment_outcome_code = "Pass"
ids of the candidates = candidate_id; have an outcome code of Pass refers to asessment_outcome_code = 'Pass';