Return all the committees that have delegates from Democratic Party.
select t1.committee from election as t1 join party as t2 on t1.party = t2.party_id where t2.party = "Democratic"
Hmm. Please return all the committees that have delegates from Liberal party.
select t1.committee from election as t1 join party as t2 on t1.party = t2.party_id where t2.party = "Liberal"
Please give me all the delegates's names from Liberal party in Appropriations committee
select t1.delegate from election as t1 join party as t2 on t1.party = t2.party_id where t2.party = "Liberal" and t1.committee = "Appropriations"
Can you also give me all the delegate's name from Liberal party in Economic Matters committee.
select t1.delegate from election as t1 join party as t2 on t1.party = t2.party_id where t2.party = "Liberal" and t1.committee = "Economic Matters"
Can you please give the delegates name from Democratic Party in economic matters committee?
select t1.delegate from election as t1 join party as t2 on t1.party = t2.party_id where t2.party = "Democratic" and t1.committee = "Economic Matters"