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
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 = value order by t1 . name
What are the names of all female candidates in alphabetical order ( sex is F ) ?