How many players have an overall rating of 60 or greater?
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.overall_rating >= 60
How many players have potential of 80 or greater?
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.potential >= 80
Of all players with an overall rating greater than 80, how many are right-footed and left-footed?
select preferred_foot, count(*) from player_attributes where overall_rating > 80 group by preferred_foot