Show all the ranks and the number of male and female faculty for each rank.
return ranks ;return faculty of #1 ;return #2 that are male ;return #2 that are female ;return number of  #3 for each #1 ;return number of  #4 for each #1 ;return #1 ,  #5 ,   #6
['select', 'project', 'filter', 'filter', 'group', 'group', 'union']