CREATE TABLE candidates (candidate_id VARCHAR)
CREATE TABLE people (first_name VARCHAR, last_name VARCHAR, person_id VARCHAR)

what are the first name and last name of all candidates?
SELECT T2.first_name, T2.last_name FROM candidates AS T1 JOIN people AS T2 ON T1.candidate_id = T2.person_id
SELECT "T2"."first_name", "T2"."last_name" FROM "candidates" AS "T1" JOIN "people" AS "T2" ON "T1"."candidate_id" = "T2"."person_id"