CREATE TABLE personfriend (name TEXT, friend TEXT, year DECIMAL)
CREATE TABLE person (name TEXT, age DECIMAL, city TEXT, gender TEXT, job TEXT)

What are the names of all females who are friends with Zach?
SELECT T1.name FROM person AS T1 JOIN personfriend AS T2 ON T1.name = T2.name WHERE T2.friend = 'Zach' AND T1.gender = 'female'
SELECT "T1"."name" FROM "person" AS "T1" JOIN "personfriend" AS "T2" ON "T1"."name" = "T2"."name" AND "T2"."friend" = 'Zach' WHERE "T1"."gender" = 'female'