Task: Text to Code
Input (English): Find id of candidates whose assessment code is "Pass"?
Output (English): SELECT candidate_id FROM candidate_assessments WHERE asessment_outcome_code = "Pass"