user: Question: When less than 30 games have been played what is the average goals scored?
Columns: ['Position', 'Club', 'Games played', 'Wins', 'Draws', 'Loses', 'Goals scored', 'Goals conceded', 'Points']
Types: ['real', 'text', 'real', 'real', 'real', 'real', 'real', 'real', 'real']
Sample row: [1.0, 'Polonija Vilnius', 30.0, 27.0, 0.0, 3.0, 97.0, 16.0, 81.0]
SQL:

assistant: SELECT AVG("Goals scored") FROM "Table" WHERE "Games played" < 30.0;