How many male and female assistant professors do we have?
return assistant professors ;return #1 that  are  male ;return #1 that  are  female ;return number of  #2 ;return number of  #3 ;return #4 ,  #5
['select', 'filter', 'filter', 'aggregate', 'aggregate', 'union']