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
List the names of people that are not entrepreneurs.
assistant
SELECT Name FROM people WHERE People_ID NOT IN (SELECT People_ID FROM entrepreneur)
human
What are the investors of entrepreneurs and the corresponding number of entrepreneurs invested by each investor?
assistant
SELECT Investor , COUNT(*) FROM entrepreneur GROUP BY Investor
human
What are the names of entrepreneurs?
assistant
SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID
human
What is the investor that has invested in the most number of entrepreneurs?
assistant
SELECT Investor FROM entrepreneur GROUP BY Investor ORDER BY COUNT(*) DESC LIMIT 1
human
List the companies and the investors of entrepreneurs.
assistant
SELECT Company , Investor FROM entrepreneur
human
Count the number of entrepreneurs.
assistant
SELECT COUNT( * ) FROM entrepreneur ;