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

Question: What was the 2008 election status when glenn nye was the running democrat?
SQL: SELECT "2008_status" FROM va_2008_elections WHERE "democratic" = 'Glenn Nye'

Question: Who was the republican candidate in the race with incumbent thelma drake?
SQL: SELECT "republican" FROM va_2008_elections WHERE "incumbent" = 'Thelma Drake'

Question: How many districts had republican Bob Goodlatte as a candidate?
SQL: SELECT COUNT("district") FROM va_2008_elections WHERE "republican" = 'Bob Goodlatte'

Question: Who was the democratic candidate when the republican was  frank wolf?
SQL: SELECT "democratic" FROM va_2008_elections WHERE "republican" = 'Frank Wolf'