Find the names of females who are friends with Zach
CREATE TABLE person (
    name text,
    age number,
    city text,
    gender text,
    job text
)

CREATE TABLE personfriend (
    name text,
    friend text,
    year number
)
SELECT T1.name FROM person AS T1 JOIN personfriend AS T2 ON T1.name = T2.name WHERE T2.friend = 'Zach' AND T1.gender = 'female'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: Find the names of females who are friends with Zach ### Input: CREATE TABLE person (
    name text,
    age number,
    city text,
    gender text,
    job text
)

CREATE TABLE personfriend (
    name text,
    friend text,
    year number
) ### Response: SELECT T1.name FROM person AS T1 JOIN personfriend AS T2 ON T1.name = T2.name WHERE T2.friend = 'Zach' AND T1.gender = 'female'