find the number of players whose points are lower than 30 in each position.
SELECT count(*) ,  POSITION FROM player WHERE points  <  30 GROUP BY POSITION
number of players whose points are lower than 30 = COUNT(*) WHERE points < 30; in each position = GROUP BY POSITION;