Table: city_executive
Columns: office
type
location
elected
term_began
term_ended

Question: When did the term end that began January 3, 2007?
SQL: SELECT "term_ended" FROM city_executive WHERE "term_began" = 'January 3, 2007'

Question: When did the term began when the date of election is N/A?
SQL: SELECT "term_began" FROM city_executive WHERE "elected" = 'N/A'

Question: When did the term end that began December 4, 1978?
SQL: SELECT "term_ended" FROM city_executive WHERE "term_began" = 'December 4, 1978'

Question: When did the term begin that ended January 3, 1995?
SQL: SELECT "term_began" FROM city_executive WHERE "term_ended" = 'January 3, 1995'

Question: What branch of government was the term that ended on January 3, 2001?
SQL: SELECT "type" FROM city_executive WHERE "term_ended" = 'January 3, 2001'