Who are the delegates on the Appropriations committee?
select delegate from election where committee = 'Appropriations'
What counties are they from?
select t1.county_name from county as t1 join election as t2 where t1.county_id = district and t2.committee = 'Appropriations'
What districts are they from?
select district from election where committee = 'Appropriations'
What are the populations of the counties they come from, please?
select t1.population from county as t1 join election as t2 where t1.county_id = district and t2.committee = 'Appropriations'