Tell me all the names of the counties.
select county_name from county
Okay. I want to know their delegates.
select t2.delegate from county as t1 join election as t2 on t1.county_id = t2.district
Which one's committee is "Appropriations"?
select t1.county_name from county as t1 join election as t2 on t1.county_id = t2.district where t2.committee = "Appropriations"