How many parties in this table?
select count ( distinct party ) from party
Peter Vallone	in which party?
select party from party where governor = "Peter Vallone"
How many elections in this table?
select count ( * ) from election
Carl McCall in which party?
select party from party where governor = "Carl McCall"
What are the names of parties that have both delegates on "Appropriations"?
select t2.party from election as t1 join party as t2 on t1.party = t2.party_id where t1.committee = "Appropriations" intersect select t2.party from election as t1 join party as t2 on t1.party = t2.party_id where t1.committee = "Economic Matters"