What is the average last cf of the st. louis blues, who has less than 4 cf appearances and less than 1 cf wins?
CREATE TABLE "team_totals" (
  "team" text,
  "cf_appearances" real,
  "cf_wins" real,
  "cup_wins" real,
  "last_cf" real
);
SELECT AVG("last_cf") FROM "team_totals" WHERE "cf_appearances"<4 AND "cf_wins"<1 AND "team"='st. louis blues';