Find the cell mobile number of the candidates whose assessment code is "Fail"?
create table candidates (candidate_id varchar, PRIMARY KEY (candidate_id)); create table people (cell_mobile_number varchar, person_id varchar, PRIMARY KEY (cell_mobile_number)); create table candidate_assessments (candidate_id varchar, asessment_outcome_code varchar, PRIMARY KEY (candidate_id))
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"