CREATE TABLE table_49074 ("Year" FLOAT, "Title" CLOB, "Producer" CLOB, "Narrator" CLOB, "Author" CLOB, "Citation" CLOB)

who is the author for harry potter and the deathly hallows?
SELECT "Author" FROM table_49074 WHERE "Title" = 'harry potter and the deathly hallows'
SELECT "Author" FROM "table_49074" WHERE "Title" = 'harry potter and the deathly hallows'