WHAT IS THE AVERAGE SQUAD NUMBER WITH MARTIN SMITH, AND LEAGUE GOALS LESS THAN 17?
CREATE TABLE "appearances_and_goals" (
  "squad_no" real,
  "name" text,
  "position" text,
  "league_apps" text,
  "league_goals" real,
  "fa_cup_apps" text,
  "fa_cup_goals" real,
  "league_cup_apps" text,
  "league_cup_goals" real,
  "flt_apps" text,
  "flt_goals" real,
  "total_apps" text,
  "total_goals" real
);
SELECT AVG("squad_no") FROM "appearances_and_goals" WHERE "name"='martin smith' AND "league_goals"<17;