How many Matches have an Average larger than 26.53, and an S/Rate of 165.4, and a 100s smaller than 1?
CREATE TABLE "runs" (
  "player" text,
  "team" text,
  "matches" real,
  "inns" real,
  "runs" real,
  "balls" real,
  "s_rate" real,
  "100s" real,
  "average" real
);
SELECT COUNT("matches") FROM "runs" WHERE "average">26.53 AND "s_rate"=165.4 AND "100s"<1;