find the number of players whose points are lower than 30 in each position.
CREATE TABLE club_rank (
    rank number,
    club_id number,
    gold number,
    silver number,
    bronze number,
    total number
)

CREATE TABLE club (
    club_id number,
    name text,
    region text,
    start_year text
)

CREATE TABLE competition_result (
    competition_id number,
    club_id_1 number,
    club_id_2 number,
    score text
)

CREATE TABLE competition (
    competition_id number,
    year number,
    competition_type text,
    country text
)

CREATE TABLE player (
    player_id number,
    name text,
    position text,
    club_id number,
    apps number,
    tries number,
    goals text,
    points number
)
SELECT COUNT(*), position FROM player WHERE points < 30 GROUP BY position
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: find the number of players whose points are lower than 30 in each position. ### Input: CREATE TABLE club_rank (
    rank number,
    club_id number,
    gold number,
    silver number,
    bronze number,
    total number
)

CREATE TABLE club (
    club_id number,
    name text,
    region text,
    start_year text
)

CREATE TABLE competition_result (
    competition_id number,
    club_id_1 number,
    club_id_2 number,
    score text
)

CREATE TABLE competition (
    competition_id number,
    year number,
    competition_type text,
    country text
)

CREATE TABLE player (
    player_id number,
    name text,
    position text,
    club_id number,
    apps number,
    tries number,
    goals text,
    points number
) ### Response: SELECT COUNT(*), position FROM player WHERE points < 30 GROUP BY position