Which protein names are associated with an institution in a building with at least 20 floors?
select t2.protein_name from institution as t1 join protein as t2 on t1.institution_id = t2.institution_id join building as t3 on t3.building_id = t1.building_id where t3.floors >= 20
Which of those have common name equal to 'Tropical Clawed Frog'?
select t2.protein_name from institution as t1 join protein as t2 on t1.institution_id = t2.institution_id join building as t3 on t3.building_id = t1.building_id where t3.floors >= 20 and t2.common_name = 'Tropical clawed Frog'
Give a count of the proteins in the first query.
select count(*) from institution as t1 join protein as t2 on t1.institution_id = t2.institution_id join building as t3 on t3.building_id = t1.building_id where t3.floors >= 20