CREATE TABLE player (POSITION VARCHAR2, points NUMBER)

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" < 30 GROUP BY "POSITION"