what players have a overall rating greater than 80?
select * from player_attributes where overall_rating > 80
of those players how many are right-footed?
select count ( * ) from player_attributes where overall_rating > 80 and preferred_foot = 'right'
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'
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'
could add the right-footed and left-footed players that have an overall rating greater than 80 together?
select preferred_foot, count ( * ) from player_attributes where overall_rating > 80 group by preferred_foot