user: ### NOW ANSWER:
Question: Show the Residence whose Name is Rich Gordon?
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 "Residence" FROM "Table" WHERE "Name" = 'Rich Gordon';