CREATE TABLE table_name_47 (week VARCHAR, theme VARCHAR)

Which week had a theme of Heroes?
SELECT week FROM table_name_47 WHERE theme = "heroes"
SELECT "week" FROM "table_name_47" WHERE "heroes" = "theme"