List all player names who have an overall rating higher than the average.
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 > ( select avg ( overall_rating ) from player_attributes )
List all player names who have an overall rating lower than the average.
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 < ( select avg ( overall_rating ) from player_attributes )
How many players have an overall rating lower than the average?
select count ( distinct t1.id ) from player as t1 join player_attributes as t2 on t1.player_api_id = t2.player_api_id where t2.overall_rating < ( select avg ( overall_rating ) from player_attributes )
What is the average height of players that have an overall rating lower than the average?
select avg ( t1.height ) from player as t1 join player_attributes as t2 on t1.player_api_id = t2.player_api_id where t2.overall_rating < ( select avg ( overall_rating ) from player_attributes )
What is the average height of players that have an overall rating higher than the average?
select avg ( t1.height ) from player as t1 join player_attributes as t2 on t1.player_api_id = t2.player_api_id where t2.overall_rating > ( select avg ( overall_rating ) from player_attributes )