CREATE TABLE table_31166 ("District" FLOAT, "Representative" CLOB, "Party" CLOB, "Residence" CLOB, "First Elected" CLOB, "Term Limited" FLOAT)

which district does andy thompson represent
SELECT COUNT("District") FROM table_31166 WHERE "Representative" = 'Andy Thompson'
SELECT COUNT("District") FROM "table_31166" WHERE "Representative" = 'Andy Thompson'