What is the average rating for right-footed players and left-footed players?
SELECT preferred_foot ,  avg(overall_rating) FROM Player_Attributes GROUP BY preferred_foot
average rating for a category (right-footed or left-footed players) = AVG(overall_rating) grouped by preferred_foot;