How many legs were won by the player who had less than 84 100+, less than 14 legs lost, and less than 3 played?
CREATE TABLE "statistics" (
  "player" text,
  "played" real,
  "legs_won" real,
  "legs_lost" real,
  "100" real,
  "140" real,
  "180s" real,
  "high_checkout" real,
  "3_dart_average" real
);
SELECT SUM("legs_won") FROM "statistics" WHERE "100"<84 AND "legs_lost"<14 AND "played"<3;