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
Show me the name of all investors.
assistant
SELECT Investor FROM entrepreneur GROUP BY Investor;
human
Who have been requested more than 140000 by any entrepreneurs?
assistant
SELECT Investor FROM entrepreneur WHERE Money_Requested > 140000;
human
Among them, who have been requested less than 120000 by any entrepreneurs?
assistant
SELECT Investor FROM entrepreneur WHERE Money_Requested > 140000 INTERSECT SELECT Investor FROM entrepreneur WHERE Money_Requested < 120000 ;