CREATE TABLE candidates (candidate_id VARCHAR)
CREATE TABLE candidate_assessments (candidate_id VARCHAR, asessment_outcome_code VARCHAR)
CREATE TABLE people (cell_mobile_number VARCHAR, person_id VARCHAR)

Find the cell mobile number of the candidates whose assessment code is 'Fail'?
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"
SELECT "T3"."cell_mobile_number" FROM "candidates" AS "T1" JOIN "candidate_assessments" AS "T2" ON "Fail" = "T2"."asessment_outcome_code" AND "T1"."candidate_id" = "T2"."candidate_id" JOIN "people" AS "T3" ON "T1"."candidate_id" = "T3"."person_id"