Table: va_house_2008_election
Columns: district
incumbent
2008_status
democratic
republican
independent_green
libertarian
other_party

Question: What is the name of the incumbent for Glenn Nye?
SQL: SELECT "incumbent" FROM va_house_2008_election WHERE "democratic" = 'glenn nye'

Question: Who was the other party nominee that ran against Democratic Rick Boucher?
SQL: SELECT "other_party" FROM va_house_2008_election WHERE "democratic" = 'rick boucher'

Question: Who is the other party nominee for district 3?
SQL: SELECT "other_party" FROM va_house_2008_election WHERE "district" = 3