CREATE TABLE Player_Attributes (preferred_foot VARCHAR(255), overall_rating INTEGER)
What is the average rating for right-footed players and left-footed players?
    
SQL: SELECT preferred_foot, AVG(overall_rating) FROM Player_Attributes GROUP BY preferred_foot