What are the minimum and mean values of the points?
select min(points), avg(points) from player
What are the player names of those who have fewer points than the average?
select name from player where points < (select avg(points) from player)
How many are there?
select count(*) from player where points < (select avg(points) from player)
How many players are there whose points are lower than 30?
select count(*) from player where points < 30
Among those, how many players are there for each position?
select count(*), position from player where points < 30 group by position