text: Below is an context that describes a sql query, paired with an question that provides further information. Write an answer that appropriately completes the request.  # noqa: E501
  ### Context:
  CREATE TABLE Player_Attributes (preferred_foot VARCHAR, overall_rating INTEGER)
  ### Question:
  What is the average rating for right-footed players and left-footed players?
  ### Answer:
  SELECT preferred_foot, AVG(overall_rating) FROM Player_Attributes GROUP BY preferred_foot