human
Schema:
body_builder (Body_Builder_ID, People_ID, Snatch, Clean_Jerk, Total)
people (People_ID, Name, Height, Weight, Birth_Date, Birth_Place)
Please answer with SQL.
assistant
Sure, I understand.
human
Show the people Id of the body builders.
assistant
SELECT People_ID FROM body_builder;
human
Which people are there?
assistant
SELECT * FROM people WHERE people_id IN ( SELECT People_ID FROM body_builder );
human
What about people who are not there?
assistant
SELECT * FROM people WHERE people_id NOT IN ( SELECT People_ID FROM body_builder );
human
How many such people in total?
assistant
SELECT COUNT( * ) FROM people WHERE people_id NOT IN ( SELECT People_ID FROM body_builder ) ;