What is the sum of Other, when the Name is Simon Gillett Category:Articles with hCards, and when the Total is less than 34?
CREATE TABLE "appearances" (
  "name" text,
  "league" real,
  "fa_cup" real,
  "league_cup" real,
  "other" real,
  "total" real
);
SELECT SUM("other") FROM "appearances" WHERE "name"='simon gillett category:articles with hcards' AND "total"<34;