question: Show all the ranks and the number of male and female faculty for each rank.
#1 return ranks 
#2 return faculty of #1 
#3 return #2 that are male 
#4 return #2 that are female 
#5 return number of  #3 for each #1 
#6 return number of  #4 for each #1 
#7 return #1 ,  #5 ,   #6