How many red things are in front of the farthest thing?
return things ;return the  farthest #1 ;return #1 that  are red ;return #3 that  are in front of #2 ;return number of #4
['select', 'project', 'filter', 'filter', 'aggregate']