What is the name of candidate id 111?
select t3.first_name,t3.middle_name,t3.last_name 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 t1.candidate_id = 111
What is the email address of login id zops?
select t3.email_address 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 t3.login_name = "zops"
What is the assessment date of candidate id 121?
select t2.assessment_date 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.candidate_id = 121