Tell me the names of players who have an overall rating larger than 80.
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 > 80
Tell me their preferred foot.
select distinct t1.player_name, t2.preferred_foot from player as t1 join player_attributes as t2 on t1.player_api_id = t2.player_api_id where t2.overall_rating > 80
tell me the names of all left-footed players who have overall rating between 85 and 90.
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