Table schema:
CREATE TABLE player (name VARCHAR, points INTEGER)

Question: what are the name of players who get more than the average points.
SQL: SELECT name FROM player WHERE points > (SELECT AVG(points) FROM player)