SELECT count(*) ,  POSITION FROM player WHERE points  <  30 GROUP BY POSITION
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
select count ( * ) , position from player where points < value group by position
find the number of players whose points are lower than 30 in each position .