SELECT name FROM player WHERE points  >  (SELECT avg(points) FROM player)
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 )
select name from player where points > ( select avg ( points ) from player )
What are the names of all players that got more than the average number of points ?