Table: us_house_08_nc
Columns: district
incumbent
2008_status
democratic
republican

Question: Which District has a 2008 Status of re-election, and a Democratic david price?
SQL: SELECT AVG("district") FROM us_house_08_nc WHERE "2008_status" = 're-election' AND "democratic" = 'david price'

Question: Which District has a Republican of dan mansell?
SQL: SELECT AVG("district") FROM us_house_08_nc WHERE "republican" = 'dan mansell'

Question: Which Republican has a District of 10?
SQL: SELECT "republican" FROM us_house_08_nc WHERE "district" = 10

Question: Which Incumbent has a Republican of dan mansell?
SQL: SELECT "incumbent" FROM us_house_08_nc WHERE "republican" = 'dan mansell'

Question: Which Democratic has a District smaller than 7, and a Republican of dan mansell?
SQL: SELECT "democratic" FROM us_house_08_nc WHERE "district" < 7 AND "republican" = 'dan mansell'