CREATE TABLE club_rank (rank DECIMAL, club_id DECIMAL, gold DECIMAL, silver DECIMAL, bronze DECIMAL, total DECIMAL)
CREATE TABLE club (club_id DECIMAL, name TEXT, region TEXT, start_year TEXT)
CREATE TABLE competition_result (competition_id DECIMAL, club_id_1 DECIMAL, club_id_2 DECIMAL, score TEXT)
CREATE TABLE competition (competition_id DECIMAL, year DECIMAL, competition_type TEXT, country TEXT)
CREATE TABLE player (player_id DECIMAL, name TEXT, position TEXT, club_id DECIMAL, apps DECIMAL, tries DECIMAL, goals TEXT, points DECIMAL)

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"