Table: california_lgbt_caucus
Columns: name
residence
party
years_in_assembly
years_in_senate

Question: What is the political party of Jackie Goldberg?
SQL: SELECT "party" FROM california_lgbt_caucus WHERE "name" = 'jackie goldberg'

Question: During what years was Christine Kehoe in Assembly?
SQL: SELECT "years_in_assembly" FROM california_lgbt_caucus WHERE "name" = 'christine kehoe'

Question: What were the San Francisco resident's years in assembly?
SQL: SELECT "years_in_assembly" FROM california_lgbt_caucus WHERE "residence" = 'san francisco'

Question: What political party does the person from San Diego belong to?
SQL: SELECT "party" FROM california_lgbt_caucus WHERE "residence" = 'san diego'