CREATE TABLE people (name VARCHAR2, people_id VARCHAR2, sex VARCHAR2)
CREATE TABLE candidate (people_id VARCHAR2)

list all female (sex is F) candidate names in the alphabetical order.
SELECT t1.name FROM people AS t1 JOIN candidate AS t2 ON t1.people_id = t2.people_id WHERE t1.sex = 'F' ORDER BY t1.name
SELECT "t1"."name" FROM "people" "t1" JOIN "candidate" "t2" ON "t1"."people_id" = "t2"."people_id" WHERE "t1"."sex" = 'F' ORDER BY "t1"."name"