Table: black_knights
Columns: swedish_title
norwegian_title
translated_title
published
pages
isbn

Question: I want the sum of pages for thistle among roses
SQL: SELECT SUM("pages") FROM black_knights WHERE "translated_title" = 'thistle among roses'