Abaixo está uma instrução que descreve uma tarefa de geração de SQL, combinada com uma entrada que fornece mais contexto sobre os esquemas de tabela disponíveis. Escreva o código SQL que responda adequadamente à solicitação
 ###Instrução: qual distrito andy thompson representa
 ###Tabelas: CREATE TABLE international_broadcasts (international_broadcasts_id AUTO_INCREMENT PRIMARY KEY, Country VARCHAR, TV Network(s) VARCHAR, Series Premiere VARCHAR, Weekly Schedule VARCHAR, Status VARCHAR) CREATE TABLE house_of_representatives (house_of_representatives_id AUTO_INCREMENT PRIMARY KEY, District INT, Representative VARCHAR, Party VARCHAR, Residence VARCHAR, First Elected VARCHAR, Term Limited INT) CREATE TABLE doubles_2–4 (doubles_2–4_id AUTO_INCREMENT PRIMARY KEY, Outcome VARCHAR, Date VARCHAR, Tournament VARCHAR, Surface VARCHAR, Partner VARCHAR, Opponents VARCHAR, Score VARCHAR) CREATE TABLE notable_organs (notable_organs_id AUTO_INCREMENT PRIMARY KEY, Date INT, Country VARCHAR, Place VARCHAR, Building VARCHAR, Size VARCHAR) CREATE TABLE largest_nordic_companies_according_to_forbes (largest_nordic_companies_according_to_forbes_id AUTO_INCREMENT PRIMARY KEY, Rank VARCHAR, Company VARCHAR, Headquarters VARCHAR, Industry VARCHAR, Revenue (billion $ ) INT, Profits (billion $) INT, s Asset (billion $) INT, Market value (billion $) INT)  
SELECT COUNT District FROM house_of_representatives WHERE Representative = Andy Thompson