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