What is the average rating for right-footed players and left-footed players?
CREATE TABLE Player_Attributes (
    preferred_foot VARCHAR,
    overall_rating INTEGER
)
SELECT preferred_foot, AVG(overall_rating) FROM Player_Attributes GROUP BY preferred_foot
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: What is the average rating for right-footed players and left-footed players? ### Input: CREATE TABLE Player_Attributes (
    preferred_foot VARCHAR,
    overall_rating INTEGER
) ### Response: SELECT preferred_foot, AVG(overall_rating) FROM Player_Attributes GROUP BY preferred_foot