How many institutions do not have an associated protein in our record?
CREATE TABLE protein (institution_id VARCHAR); CREATE TABLE institution (institution_id VARCHAR)
SELECT COUNT(*) FROM institution WHERE NOT institution_id IN (SELECT institution_id FROM protein)
### Context: CREATE TABLE protein (institution_id VARCHAR); CREATE TABLE institution (institution_id VARCHAR) ### Question: How many institutions do not have an associated protein in our record? ### Answer: SELECT COUNT(*) FROM institution WHERE NOT institution_id IN (SELECT institution_id FROM protein)