CREATE TABLE table_name_2 (award VARCHAR, result VARCHAR, year VARCHAR)

What award was Trent Tesoro nominated for in 2007?
SELECT award FROM table_name_2 WHERE result = "nominated" AND year = 2007
SELECT "award" FROM "table_name_2" WHERE "nominated" = "result" AND "year" = 2007