Table: awards_nominations
Columns: year
category
nominee_s
episode
result

Question: Which nominees won before year 2005?
SQL: SELECT "nominee_s" FROM awards_nominations WHERE "year" < 2005 AND "result" = 'won'

Question: Which episode in year 2003 that have Gary Murphy and Neil Thompson?
SQL: SELECT "episode" FROM awards_nominations WHERE "nominee_s" = 'gary murphy and neil thompson' AND "year" = 2003

Question: What is the average year with nominated result?
SQL: SELECT AVG("year") FROM awards_nominations WHERE "result" = 'nominated'