human
Schema:
entrepreneur (Entrepreneur_ID, People_ID, Company, Money_Requested, Investor)
people (People_ID, Name, Height, Weight, Date_of_Birth)
Please answer with SQL.
assistant
Sure, I understand.
human
Hi! Can you show me a list of all people and their people IDs?
assistant
SELECT Name , people_id FROM people;
human
Nice! Can you filter the list to show only the people who do not have an associated entrepreneur ID?
assistant
SELECT Name , people_id FROM people WHERE People_ID NOT IN ( SELECT People_ID FROM entrepreneur );
human
Wonderful! Can you tell me what is the total amount of money requested by the people who ARE entrepreneurs?
assistant
SELECT SUM( money_requested ) FROM entrepreneur ;