of the players with an overall rating greater than 80 how many are right-footed?
SELECT count ( * )  FROM Player_Attributes WHERE overall_rating  >  80 and preferred_foot  =  'right'
players with an overall rating greater than 80 refers to overall_rating > 80; how many are right-footed refers to COUNT(*) WHERE preferred_foot = 'right';