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
players with an overall rating greater than 80 refers to overall_rating > 80; count of right-footed and left-footed players is derived from grouping by preferred_foot and counting;