Show the institution names joined with the protein names.
select t1.institution, t2.protein_name from institution as t1 join protein as t2 on t1.institution_id = t2.institution_id
Aggregate, count, over the institution names.
select t1.institution, count(*) from institution as t1 join protein as t2 on t1.institution_id = t2.institution_id group by t1.institution_id