Table: kagasoff_awards
Columns: year
award
work
category
result

Question: What is the latest year they were nominated?
SQL: SELECT MAX("year") FROM kagasoff_awards WHERE "result" = 'nominated'

Question: What is the result of the choice tv actor: drama category?
SQL: SELECT "result" FROM kagasoff_awards WHERE "category" = 'choice tv actor: drama'