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