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"
SELECT candidate_id FROM candidate_assessments WHERE asessment_outcome_code = "Pass"
[{'candidate_id': 111}, {'candidate_id': 121}, {'candidate_id': 141}, {'candidate_id': 151}]