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