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, could you please let me know the date of birth of the investors Simon Woodroffe and Peter Jones?
assistant
SELECT T2.Date_of_Birth FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID WHERE T1.Investor = 'Simon Woodroffe' OR T1.Investor = 'Peter Jones';
human
That was really quick, thank you. Then can you please tell me how much money they requested, respectively?
assistant
SELECT Money_Requested FROM entrepreneur WHERE Investor = 'Simon Woodroffe' OR Investor = 'Peter Jones';
human
haha I am sorry, Thanks again for your answer! :) Then could you please let me know which entrepreneur requested for the biggest amount of money?
assistant
SELECT Entrepreneur_ID FROM entrepreneur ORDER by Money_Requested desc LIMIT 1 ;