How many persons are not body builders?
CREATE TABLE body_builder (people_id VARCHAR, People_ID VARCHAR); CREATE TABLE people (people_id VARCHAR, People_ID VARCHAR)
SELECT COUNT(*) FROM people WHERE NOT people_id IN (SELECT People_ID FROM body_builder)
### Context: CREATE TABLE body_builder (people_id VARCHAR, People_ID VARCHAR); CREATE TABLE people (people_id VARCHAR, People_ID VARCHAR) ### Question: How many persons are not body builders? ### Answer: SELECT COUNT(*) FROM people WHERE NOT people_id IN (SELECT People_ID FROM body_builder)