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 weights of entrepreneurs in descending order of money requested?
assistant
SELECT T2.Weight FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID ORDER BY T1.Money_Requested DESC
human
What is the total money requested by entrepreneurs with height more than 1.85?
assistant
SELECT sum(T1.Money_Requested) FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID WHERE T2.Height > 1.85
human
What is the name of the entrepreneur with the greatest weight?
assistant
SELECT T2.Name FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID ORDER BY T2.Weight DESC LIMIT 1
human
Show the company of the tallest entrepreneur.
assistant
SELECT T1.Company FROM entrepreneur AS T1 JOIN people AS T2 ON T1.People_ID = T2.People_ID ORDER BY T2.Height DESC LIMIT 1
human
What are the names of people in ascending order of weight?
assistant
SELECT Name FROM People ORDER BY Weight ASC
human
Return the weight of the shortest person.
assistant
SELECT Weight FROM people ORDER BY Height ASC LIMIT 1 ;