How many San Jose wins have an LA goals larger than 6, and an LA wins smaller than 21?
CREATE TABLE "games" (
  "la_wins" real,
  "draws" real,
  "san_jose_wins" real,
  "la_goals" real,
  "san_jose_goals" real
);
SELECT COUNT("san_jose_wins") FROM "games" WHERE "la_goals">6 AND "la_wins"<21;