Below is an instruction that describes a task. Write a response that appropriately completes the request.

### Instruction:
What were the San Francisco resident's years in assembly?

### Inputs:
table_name: table, columns: ['Name', 'Residence', 'Party', 'Years in Assembly', 'Years in Senate']

### Response:
SELECT Years in Assembly FROM table WHERE Residence = san francisco