SELECT count(*) FROM institution WHERE institution_id NOT IN (SELECT institution_id FROM protein)
How many institutions do not have an associated protein in our record?
SELECT count ( * ) FROM institution WHERE institution_id NOT IN ( SELECT institution_id FROM protein )
select count ( * ) from institution where institution_id not in ( select institution_id from protein )
How many institutions do not have an associated protein in our record ?