Schema: CREATE TABLE table_name_2 (award VARCHAR, result VARCHAR, year VARCHAR)
Question: What award was Trent Tesoro nominated for in 2007?
SQL: SELECT award FROM table_name_2 WHERE result = "nominated" AND year = 2007