Table: odyssey_award
Columns: year
title
producer
narrator
author
citation

Question: who is the author for harry potter and the deathly hallows?
SQL: SELECT "author" FROM odyssey_award WHERE "title" = 'harry potter and the deathly hallows'

Question: what is the title when the citation is honor and the narrator is lincoln hoppe?
SQL: SELECT "title" FROM odyssey_award WHERE "citation" = 'honor' AND "narrator" = 'lincoln hoppe'

Question: who is the producer when the narrator is katherine kellgren, the year is before 2013 and the author is karen cushman?
SQL: SELECT "producer" FROM odyssey_award WHERE "narrator" = 'katherine kellgren' AND "year" < 2013 AND "author" = 'karen cushman'

Question: what is the year when the citation is honor and the author is kadir nelson?
SQL: SELECT SUM("year") FROM odyssey_award WHERE "citation" = 'honor' AND "author" = 'kadir nelson'