CREATE TABLE table_29486189_4 (district VARCHAR, representative VARCHAR)

which district does andy thompson represent
SELECT COUNT(district) FROM table_29486189_4 WHERE representative = "Andy Thompson"
SELECT COUNT("district") FROM "table_29486189_4" WHERE "Andy Thompson" = "representative"