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
What are the investor name of Leonardo Binchi?
assistant
SELECT T1.Investor FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Name = 'Leonardo Binchi';
human
What is the total amount of money requested for three persons? | Sorry, which three persons do you want? | The three persons are Francesco Postiglione, Leonardo Binchi and Fabrizio Buonocore
assistant
SELECT SUM( T1.Money_Requested ) FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Name = 'Francesco Postiglione' OR T2.Name = 'Leonardo Binchi' OR T2.Name = 'Fabrizio Buonocore';
human
What is the company name of Fabrizio Buonocore?
assistant
SELECT T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Name = 'Fabrizio Buonocore';
human
What are the name of entrepreneurs whose investor is not 'Rachel Elnaugh'?
assistant
SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID WHERE T1.Investor ! = "Rachel Elnaugh" ;