CREATE TABLE candidate (people_id VARCHAR(255)); CREATE TABLE people (name VARCHAR(255), people_id VARCHAR(255), sex VARCHAR(255))
list all female (sex is F) candidate names in the alphabetical order.
    
SQL: 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