how many faculties?
select count ( * ) from faculty
How many female faculties?
select count ( * ) from faculty where sex = 'F'
How many professors?
select count ( * ) from faculty where rank = 'Professor'