Database: sports_competition
Question: find the number of players whose points are lower than 30 in each position.
SQL:
SELECT count(*) ,  POSITION FROM player WHERE points  <  30 GROUP BY POSITION