Tell me all the information about the counties.
select * from county
For now, I just want to know the parties.
select distinct t1.county_name, t3.party from county as t1 join election as t2 on t1.county_id = t2.district join party as t3 on t2.party = t3.party_id
I also want to know the number of delegates of these parties.
select t2.party, count(*) from election as t1 join party as t2 on t1.party = t2.party_id group by t1.party