Task: Text to Code
Input (English): Of all players with an overall rating greater than 80, how many are right-footed and left-footed?
Output (English): SELECT preferred_foot ,  count(*) FROM Player_Attributes WHERE overall_rating  >  80 GROUP BY preferred_foot