CREATE TABLE candidates (candidate_id VARCHAR(255)); CREATE TABLE people (cell_mobile_number VARCHAR(255), person_id VARCHAR(255)); CREATE TABLE candidate_assessments (candidate_id VARCHAR(255), asessment_outcome_code VARCHAR(255))
Find the cell mobile number of the candidates whose assessment code is "Fail"?
    
SQL: SELECT T3.cell_mobile_number FROM candidates AS T1 JOIN candidate_assessments AS T2 ON T1.candidate_id = T2.candidate_id JOIN people AS T3 ON T1.candidate_id = T3.person_id WHERE T2.asessment_outcome_code = "Fail"