What is the toal rec with more than 27 and averages less than 10.8 and TDs more than 6?
CREATE TABLE "receiving" (
  "player" text,
  "rec" real,
  "yards" real,
  "avg" real,
  "td_s" real,
  "long" real
);
SELECT COUNT("long") FROM "receiving" WHERE "rec">27 AND "avg"<10.8 AND "td_s">6;