CREATE TABLE people (people_id DECIMAL, sex TEXT, name TEXT, date_of_birth TEXT, height DECIMAL, weight DECIMAL)
CREATE TABLE candidate (candidate_id DECIMAL, people_id DECIMAL, poll_source TEXT, date TEXT, support_rate DECIMAL, consider_rate DECIMAL, oppose_rate DECIMAL, unsure_rate DECIMAL)

What are the names of all female candidates in alphabetical order (sex is F)?
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" AS "t1" JOIN "candidate" AS "t2" ON "t1"."people_id" = "t2"."people_id" WHERE "t1"."sex" = 'F' ORDER BY "t1"."name" NULLS FIRST