who is the author for harry potter and the deathly hallows?
CREATE TABLE table_49074 (
    "Year" real,
    "Title" text,
    "Producer" text,
    "Narrator" text,
    "Author" text,
    "Citation" text
)
SELECT "Author" FROM table_49074 WHERE "Title" = 'harry potter and the deathly hallows'
Below are sql tables schemas paired with instruction that describes a task. Using valid SQLite, write a response that appropriately completes the request for the provided tables. ### Instruction: who is the author for harry potter and the deathly hallows? ### Input: CREATE TABLE table_49074 (
    "Year" real,
    "Title" text,
    "Producer" text,
    "Narrator" text,
    "Author" text,
    "Citation" text
) ### Response: SELECT "Author" FROM table_49074 WHERE "Title" = 'harry potter and the deathly hallows'