Table: us_elections_2000
Columns: year
governor
lieutenant_governor
secretary_of_state
attorney_general
treasurer
state_senate
state_assembly
u_s_senator_class_i
u_s_senator_class_iii
u_s_house
electoral_college_votes

Question: Who was treasurer in 2008?
SQL: SELECT "treasurer" FROM us_elections_2000 WHERE "year" = '2008'

Question: What was the composition of the state assembly in 2008?
SQL: SELECT "state_assembly" FROM us_elections_2000 WHERE "year" = '2008'