When less than 30 games have been played what is the average goals scored?
CREATE TABLE table_name_18 (
    goals_scored INTEGER,
    games_played INTEGER
)
SELECT AVG(goals_scored) FROM table_name_18 WHERE games_played < 30
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: When less than 30 games have been played what is the average goals scored? ### Input: CREATE TABLE table_name_18 (
    goals_scored INTEGER,
    games_played INTEGER
) ### Response: SELECT AVG(goals_scored) FROM table_name_18 WHERE games_played < 30