Which average match has a lost greater than 0, points greater than 6, legia warszawa as the team, and a draw less than 0?
CREATE TABLE "first_league" (
  "team" text,
  "match" real,
  "points" real,
  "draw" real,
  "lost" real
);
SELECT AVG("match") FROM "first_league" WHERE "lost">0 AND "points">6 AND "team"='legia warszawa' AND "draw"<0;