What is the average rating for right-footed players and left-footed players?
select preferred_foot, avg(overall_rating) from player_attributes group by preferred_foot