What are the maximum and mean values of the points?
select max(points), avg(points) from player
What are the player names of those who have more points than the average?
select name from player where points > (select avg(points) from player)