user: ### NOW ANSWER:
Question: What were the San Francisco resident's years in assembly?
Columns: ['Name', 'Residence', 'Party', 'Years in Assembly', 'Years in Senate']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Sheila Kuehl', 'Santa Monica', 'Democratic', '1994–2000', '2000–2008']
SQL:

assistant: SELECT "Years in Assembly" FROM "Table" WHERE "Residence" = 'San Francisco';