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