Database: conference
Question: For each institution id , how many staff members does each institution have that was founded after 1800 ? return their names .
SQL:
select t1.institution_name ,  count(*) from institution as t1 join staff as t2 on t1.institution_id  =  t2.institution_id where t1.founded  >  1800 group by t2.institution_id