When less than 30 games have been played what is the average goals scored?
CREATE TABLE "1_lyga" (
  "position" real,
  "club" text,
  "games_played" real,
  "wins" real,
  "draws" real,
  "loses" real,
  "goals_scored" real,
  "goals_conceded" real,
  "points" real
);
SELECT AVG("goals_scored") FROM "1_lyga" WHERE "games_played"<30;