CREATE TABLE table_name_36 (pages INT, translated_title VARCHAR)

I want the sum of pages for thistle among roses
SELECT SUM(pages) FROM table_name_36 WHERE translated_title = "thistle among roses"
SELECT SUM("pages") FROM "table_name_36" WHERE "thistle among roses" = "translated_title"