CREATE TABLE Player_Attributes (preferred_foot VARCHAR2, overall_rating NUMBER)

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
SELECT "preferred_foot", AVG("overall_rating") FROM "Player_Attributes" GROUP BY "preferred_foot"