CREATE TABLE Player_Attributes (preferred_foot VARCHAR2, overall_rating NUMBER)

Of all players with an overall rating greater than 80, how many are right-footed and left-footed?
SELECT preferred_foot, COUNT(*) FROM Player_Attributes WHERE overall_rating > 80 GROUP BY preferred_foot
SELECT "preferred_foot", COUNT(*) FROM "Player_Attributes" WHERE "overall_rating" > 80 GROUP BY "preferred_foot"