user: ### NOW ANSWER:
Question: which district does Andy Thompson represent
Columns: ['District', 'Representative', 'Party', 'Residence', 'First Elected', 'Term Limited']
Types: ['real', 'text', 'text', 'text', 'text', 'real']
Sample row: [1.0, 'Craig Newbold', 'Republican', 'Columbiana', '2010', 2018.0]
SQL:

assistant: SELECT COUNT("District") FROM "Table" WHERE "Representative" = 'Andy Thompson';