list all female (sex is F) candidate names in the alphabetical order.
create table candidate (people_id varchar, PRIMARY KEY (people_id)); create table people (name varchar, people_id varchar, sex varchar, PRIMARY KEY (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