SCHEMA:
CREATE TABLE Player_Attributes (preferred_foot VARCHAR, overall_rating INTEGER)
USER:
Of all players with an overall rating greater than 80, how many are right-footed and left-footed?

QUERY:
SELECT preferred_foot, COUNT(*) FROM Player_Attributes WHERE overall_rating > 80 GROUP BY preferred_foot