Database: candidate_poll
Question: What are the names of all female candidates in alphabetical order (sex is F)?
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