How many players have heading accuracy larger than 70?
select count(distinct t1.player_name) from player as t1 join player_attributes as t2 on t1.player_api_id = t2.player_api_id where t2.heading_accuracy > 70
Tell me the top three of these?
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.heading_accuracy > 70 order by overall_rating desc limit 3
Who are the top 3 players in terms of overall rating?
select distinct t1.player_name from player as t1 join player_attributes as t2 on t1.player_api_id = t2.player_api_id order by overall_rating desc limit 3