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 partido político a pessoa de San Diego pertence?
 ###Tabelas: CREATE TABLE former_members (former_members_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Residence VARCHAR, Party VARCHAR, Years in Assembly VARCHAR, Years in Senate VARCHAR) CREATE TABLE male_names (male_names_id AUTO_INCREMENT PRIMARY KEY, Region (year) VARCHAR, No. 1 VARCHAR, No. 2 VARCHAR, No. 3 VARCHAR, No. 4 VARCHAR, No. 5 VARCHAR, No. 6 VARCHAR, No. 7 VARCHAR, No. 8 VARCHAR, No. 9 VARCHAR, No. 10 VARCHAR) CREATE TABLE ohio_counties_ranked_by_per_capita_income (ohio_counties_ranked_by_per_capita_income_id AUTO_INCREMENT PRIMARY KEY, County VARCHAR, Per capita income VARCHAR, Median household income VARCHAR, Median family income VARCHAR, Population INT, Number of households INT) CREATE TABLE nine_pieces (nine_pieces_id AUTO_INCREMENT PRIMARY KEY, Standard order INT, English translation VARCHAR, Transcription (based on Pinyin) VARCHAR, Traditional Chinese VARCHAR, Simplified Chinese VARCHAR) CREATE TABLE thames-coromandel_district (thames-coromandel_district_id AUTO_INCREMENT PRIMARY KEY, Name VARCHAR, Years VARCHAR, Gender VARCHAR, Area VARCHAR, Authority VARCHAR, Decile INT, Roll INT)  
SELECT Party FROM former_members WHERE Residence = san diego