How many female Professors do we have?
select count(*) from faculty where sex = 'F' and rank = "Professor"