SELECT candidate_id FROM candidate_assessments WHERE asessment_outcome_code = "Pass"
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 = value
What are the ids of the candidates that have an outcome code of Pass ?