Database: student_assessment
Question: What are the ids of the candidates that have an outcome code of Pass?
SQL:
SELECT candidate_id FROM candidate_assessments WHERE asessment_outcome_code = "Pass"