Find the qualifications of the candidates with assessment code "Pass"
select qualification from candidate_assessments where asessment_outcome_code = "Pass"
Give their candidate details instead.
select t1.candidate_details from candidates as t1 join candidate_assessments as t2 on t1.candidate_id = t2.candidate_id where t2.asessment_outcome_code = "Pass"
What about with assessment code "Fail"
select t1.candidate_details from candidates as t1 join candidate_assessments as t2 on t1.candidate_id = t2.candidate_id where t2.asessment_outcome_code = "Fail"
Find the cell mobile number instead.
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"