Table: mark_leno
Columns: name
residence
party
years_in_assembly
years_in_senate

Question: Which Party has a Residence of san diego?
SQL: SELECT "party" FROM mark_leno WHERE "residence" = 'san diego'

Question: Which Years in Senate  has a Years in Assembly of 2010–present, and toni atkins?
SQL: SELECT "years_in_senate" FROM mark_leno WHERE "years_in_assembly" = '2010–present' AND "name" = 'toni atkins'

Question: Which Party has Years in Senate of —, and  Years in Assembly of 2012–present?
SQL: SELECT "party" FROM mark_leno WHERE "years_in_senate" = '—' AND "years_in_assembly" = '2012–present'

Question: Show the Residence whose Name is rich gordon?
SQL: SELECT "residence" FROM mark_leno WHERE "name" = 'rich gordon'

Question: Which Years in Assembly has a Name of toni atkins?
SQL: SELECT "years_in_assembly" FROM mark_leno WHERE "name" = 'toni atkins'

Question: Which Party has Years in Assembly of 2008–present, and a Name of tom ammiano?
SQL: SELECT "party" FROM mark_leno WHERE "years_in_assembly" = '2008–present' AND "name" = 'tom ammiano'