tell me which parties have delegates on the "Appropriations" committee?
select t2.party from election as t1 join party as t2 on t1.party = t2.party_id where t1.committee = "Appropriations"
So how about the ones with delegates on the "Economic Matters" committee?
select t2.party from election as t1 join party as t2 on t1.party = t2.party_id where t1.committee = "Economic Matters"
Okay. I want to know which ones have delegates on both.
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"