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