If one photo has at least one male wearing a purple tie that is visible.
return male ;return tie ;return #2 that is purple ;return #1 that is wearing #3 ;return photos ;return number of  #4 for each  #5 ;return #5 where  #6 is at least one ;return number of  #7 ;return if  #8 is equal to  one
['select', 'select', 'filter', 'filter', 'select', 'group', 'comparative', 'aggregate', 'boolean']