user: ### NOW ANSWER:
Question: Which Party has a Residence of San Diego?
Columns: ['Name', 'Residence', 'Party', 'Years in Assembly', 'Years in Senate']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Mark Leno', 'San Francisco', 'Democratic', '2002–2008', '2008–present']
SQL:

assistant: SELECT "Party" FROM "Table" WHERE "Residence" = 'San Diego';