What is the average rating for right-footed players and left-footed players?
return players  ;return #1 who are right-footed ;return #1 who are left-footed ;return #2 ,  #3 ;return ratings of #4 ;return average of #5
['select', 'filter', 'filter', 'union', 'project', 'aggregate']