yes
select distinct t1.player_name from player as t1 join player_attributes as t2 on t1.player_api_id = t2.player_api_id where t2.overall_rating > = 85 and t2.overall_rating < = 90
Of them which are left footed?
select distinct t1.player_name from player as t1 join player_attributes as t2 on t1.player_api_id = t2.player_api_id where t2.preferred_foot = "left" and t2.overall_rating > = 85 and t2.overall_rating < = 90
What about the names of right-footed players?
select distinct t1.player_name from player as t1 join player_attributes as t2 on t1.player_api_id = t2.player_api_id where t2.preferred_foot = "right"