I want the sum of pages for thistle among roses
CREATE TABLE "titles" (
  "swedish_title" text,
  "norwegian_title" text,
  "translated_title" text,
  "published" real,
  "pages" real,
  "isbn" text
);
SELECT SUM("pages") FROM "titles" WHERE "translated_title"='thistle among roses';