Tell me all the players whose defensive work rate is high.
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.defensive_work_rate = "high"
How about players whose attacking work rate is high?
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.defensive_work_rate = "high" and t2.attacking_work_rate = "high"
Tell me the names of all players who have a crossing score higher than 90 and prefer their right foot.
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.crossing > 90 and t2.preferred_foot = "right"