Task: Text to Code
Input (English): What is the average rating for right-footed players and left-footed players?
Output (English): SELECT preferred_foot ,  avg(overall_rating) FROM Player_Attributes GROUP BY preferred_foot