What are the names of all players that got more than the average number of points?
SELECT name FROM player WHERE points  >  (SELECT avg(points) FROM player)
names of all players = SELECT name; more than the average number of points refers to points > (SELECT AVG(points));