How many games lost for team(s) with less than 4 paints and against total of over 340?
CREATE TABLE "europe_pool_a" (
  "club" text,
  "played" real,
  "lost" real,
  "drawn" real,
  "against" real,
  "diff" real,
  "points" real
);
SELECT COUNT("lost") FROM "europe_pool_a" WHERE "points"<4 AND "against">340;