CREATE TABLE club (Club_ID NUMBER, name CLOB, Region CLOB, Start_year CLOB)
CREATE TABLE club_rank (Rank FLOAT, Club_ID NUMBER, Gold FLOAT, Silver FLOAT, Bronze FLOAT, Total FLOAT)
CREATE TABLE player (Player_ID NUMBER, name CLOB, Position CLOB, Club_ID NUMBER, Apps FLOAT, Tries FLOAT, Goals CLOB, Points FLOAT)
CREATE TABLE competition_result (Competition_ID NUMBER, Club_ID_1 NUMBER, Club_ID_2 NUMBER, Score CLOB)
CREATE TABLE competition (Competition_ID NUMBER, Year FLOAT, Competition_type CLOB, Country CLOB)

what is the number of players who have points less than 30 for each position?
SELECT Position, COUNT(*) FROM player WHERE Points < 30 GROUP BY Position
SELECT "Position", COUNT(*) FROM "player" WHERE "Points" < 30 GROUP BY "Position"