Show the number of male and female assistant professors.
return assistant professors ;return #1 that  are  male ;return number of  #2 ;return #1 that  are  female ;return number of  #4 ;return #3 ,  #5
['select', 'filter', 'aggregate', 'filter', 'aggregate', 'union']