query

I have a query that someone else created. I was able to update it to display birthdate. Now I want to limit results to gender = female. How do I do that?

Thanks!

USE ArenaDB
SELECT person_id,last_name,first_name,suffix as person_suffix,gender,birth_date,street_address_1 as address,city,state,postal_code,email
FROM core_v_person_basic AS a
WHERE 1 < (SELECT Count(*)
FROM core_v_person_basic AS b
WHERE b.first_name = a.first_name
AND b.last_name = a.last_name
AND b.street_address_1 = a.street_address_1
AND b.first_name <> '')