What are all the friends of Alice who are female?
select t2.friend from person as t1 join personfriend as t2 on t1.name = t2.friend where t2.name = 'Alice' and t1.gender = 'female'