CREATE TABLE table_29486189_4 (district VARCHAR2, representative VARCHAR2)

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"